i am working on asp application. i have a user register page and there is a image upload option , if any user upload there image that image "filename + current date" both are save in database. For example i have a table Users and there is a field called UserImage i want to save both "Filename + current date" in that field. What is procedure to save both "Filename + current date" in the database .
View 4 RepliesIn my application I have a formview, used for inserting/editing records in a product details table.
My problem is now, that one of the fields is used for the filename of a productimage, uploaded to a folder on the server from another page.
When inserting - or editing - a record, it should be possible somehow to get list of the files in the productimages folder, select one, and then store the filename (no path needed) in the database. basically I need some kind of 'file-picker' to select the filename and put it into a textbox. It could be anything from a dropdownlist to something more sofisticated - as long as I can include it in my formview.
This is my House_p table
Iamge3 Image2 Image1 Name ID
3.JPG 2.JPG 1.JPG SARA 1
I have table in database that one column is Expire date that save date like below
2015-11-23
Now I want compare it whit today date like below:
if (_dr["ExpireDate"]<DateTime.Now) {
}
But it makes error can you tell me true code for it?
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 RepliesIs there a way which allows me to save the current page of a GridView as an image?
View 2 RepliesI get a Exception while Storeing current datetime in sqlserver 2008.
UI-Sliverlight 4.0
BAL-WCf
DAL-ADO.Net Entity FrameWork
Tools-VS 2010
In Sqlserver 2008 DataBase one columns of a table is CreatedDate Having datatype :-datetime When i am passing Created Date as DateTime.Now i.e.( objRFEProxy.mCreateDate = DateTime.Now;) in sliverlight codebehind it through error. InnerException {"The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated."} System.Exception {System.Data.SqlClient.SqlException}
may i know how to add in current date into the database?i've try using INSERT INTO OrderList (Date) VALUES (DateTime.Now,"dd-MMM-yyyy")
View 3 RepliesI am trying to get the current date and time value updated into a database. I am getting an error when trying to do so though. Here is my code:
[Code]....
Does anyone see anything that throws a red flag?
I have filed image type varbinary
I want upload image and show then with click button save
store in db
I used below code for uploading image with  fileupload control
string path = Server.MapPath(".") + "../image/estate/image";
string filename = System.IO.Path.GetFileName(fup3.PostedFile.FileName);
string[] validext = { ".jpg"};
string ext = System.IO.Path.GetExtension(fup3.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
{
Label21.Text = "insert .jpg format";
[code]....
I want if users don't select any image from fileupload control in database it save this image name  'default.jpg'
If I select the today date
Then I want store 4days later date in the database
I have date in sql server 2008 database table.and now I want to compare current date with database table date.So how can i compare these two dates?
View 1 RepliesI have gridview in which i had enabled edit update function. i want to insert current date when ever a user edits the row. my web is in asp.net, vb code, and database is in sql
View 1 Repliesi have taken a ajax cal in my project and i am also using to save into db but its not saving in this format : 1900-01-01 00:00:00.000
Â
I have done:
SQL: date datatype in SQL Server 2008
I want only date to be saved! pls guide!!!!
Asp.net: cmd.Parameters.Add("@DATEOFREC", SqlDbType.DateTime).Value = txtdate.Text;
// for stringprivate string name = ""; //for date private date = DateTime.MinValue; I am not sure, how to declare this. For my insert, is inserted the current date regardless of I chppsing any date. I am not sure why?
View 1 Replies i'll need to add in current date into the database call OrderList when user click the add to cart button.
How do i do that if i want to insert using sqldatasource?
Other method are welcome too.
I am saving users information in Sql Server 2005 Database. The problems are:1. If a user selects 1/Jan/1990 then in the Age column of the database automatically 23 should be saved i.e users age, how do I calculate the age and use it in the query? 2. The format of DateofBirth column is incorrect it should be 1/Jan/1990 inspite of2013-01-01 00:00:00.000. The data type is Datetime
------------------Design is--------------
<form id="form1" runat="server">Â Â Â <div>Â Â Â Â Â Â Â
FirstName <asp:TextBox ID="TxtFirstName" runat="server"></asp:TextBox>Â Â Â Â Â Â Â
<br />    <br /> LastName    <asp:TextBox ID="TxtLastName" runat="server"></asp:TextBox>      Â
<br />  <br />       Gender   <asp:DropDownList ID="DdlGender" runat="server" Style="top: 105px; left: 80px;  Â
[Code] ....
How to save an image to the database,also referring binary data from the server to the database
View 1 RepliesFileUpload img = (FileUpload)UploadImg;
Byte[] imgByte = null;
if (img.HasFile && img.PostedFile!=null)
[code]...
How to know the FileName AjaxFileUpload in the event Click of a Button without going through earnest for this is what I found that is to say that the FileName is only in the event Designed AjaxFileUpload1_UploadComplete.
protected void InsertButton_Click(object sender, EventArgs e) {
lblMSG.Text = ViewState["filename"].ToString();
}
protected void AjaxFileUpload1_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e) {
ViewState["filename"] = e.FileName;
}
protected void AjaxFileUpload1_UploadComplete (object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e) {
string filePath = "~ / upload /" + e.FileName;
AjaxFileUpload1.SaveAs (filePath);
}
I am using file upload option in asp.net web application,how to display filename, date and time of file creation,modification date of file that we browse.
View 4 RepliesI have this path
string path = "~//ImageUploadfolder//"+ab;
In string variable, path contain this file ~//ImageUploadfolder//1.jpg .how to save this image to database as image datatype and retrieve from database to image control.
i use fileupload control in my page that save image in my database with binary data is there any way that when i upload file instead of saving binary data it save that imagename in image column?
View 1 Repliesi want to save image from html page into a folder and save its path into database table. i want to do this with save button and not with fileupload control.
View 1 Replies