show date in textbox

yengzhai · February 12th, 2005, 01:18 PM

in my database, i have a column which is of type "datetime". but i can't display it in my textbox. why?

when i look in query analyzer, the date format is "yyyymmdd hh:mm:ss". i want to have year, month and day only, is there any way for me to do that?

yengzhai

mehdi62b · February 12th, 2005, 03:00 PM

when you fetch it from DB through a DataSet or DataReader you can simply cast it and then work on DateTime value...

Code:

DateTime dt=objDataReader.GetDateTime(ColumnNumber);
//or DataSet
DateTime dt=(DateTime)ds.Tables[0].Rows[0](ColumnNumber);
textbox.Text=dt.ToString(FormatString for DateTime)

look up MSDN for DateTime and FormatString..

_____________
Mehdi.
software student.

yengzhai · February 12th, 2005, 06:15 PM

thanks a lot, mehdi!!! it works!!!

but here i have one more problem, now the problem is i can't update date into my database. it works only when i change the datatype "datetime" to "varchar". what i want to do is to fetch data (date) from database into textbox, then modify it and update it back to database. but i can't do so due to the problem that i mention above. help me pls... :(

yengzhai

mehdi62b · February 13th, 2005, 02:53 PM

when you want to update a datetime column in DB you should use DateTime structure,there is a table mapping,
nvarchar(sql)---------->System.string(.NET)
datetime(sql)---------->System.DateTime(.NET)
Money(sql)---------->System.Decimal(.NET)
so you should convert your string in the TextBox to DateTime by Parse method,something like below

Code:

//check for syntax..
DateTime dt=DateTime.Parse(TextBox1.Text);
SqlConnection objConnection=new SqlConnection(strConnection);
string upd="Update Employees SET BirthDate=@BirthDate";
upd+=" WHERE EmployeeID=@EmployeeID";
SqlCommand updCommand=new SqlCommand(upd,objConnection);
updCommand.Parameters.Add("@BirthDate",SqlDbType.DateTime);
updCommand.Parameters["@BirthDate"].Value=dt;
updCommand.Parameters.Add("@EmployeeID",SqlDbType.Int);
updCommand.Parameters["@EmployeeID"].Value=1;
objConnection.Open();
updCommand.ExecuteNonQuery();
objConnection.Close();

_____________
Mehdi.
software student.

yengzhai · February 15th, 2005, 11:45 AM

thanks again, mehdi, you are really helpful!

thanks!

yengzhai