Return only date from dataset.

Question

Hello I have a stored procedure that populates dates in SQL Server 2012 (InsDate AS date). When I execute the spoc i get InsDate=2015-06-06 which is the format I need. I retieve data into my webform using the following code: SqlCommand command = new SqlCommand(SelectSproc connection); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet ds = new DataSet(); adapter.Fill(ds); insDate.Text = ds.Tables[0].Rows[0][InsDate].ToString(); Result: insDate.Text= 2015-06-06 12:00:00 am Why do I get the time part since I'm populating only dates from the SQL? How can I get rid of the time part? Thank you in advance.

Hemlata Kushwaha · Answer

Now Try this again insDate.Text = convert.ToDateTime(ds.Tables[0].Rows[0][InsDate]).ToString( dd/MM/yyyy ); Result: ----------- 06/06/2015

Hemlata Kushwaha · Answer

Welcome!

Chriz L · Answer

That works thank you both!

Manas Mohapatra · Answer

Try below code: insDate.Text = ((DateTime) ds.Tables[0].Rows[0][InsDate] ).ToString( hh:mm:ss tt ); Make sure that value is not NULL. If you have any NULL value then before conversion you need to check NULL value.

Chriz L · Answer

Still getting the same error  Error 1 No overload for method 'ToString' takes 1 arguments

Hemlata Kushwaha · Answer

Try this insDate.Text = ds.Tables[0].Rows[0][InsDate].ToString( dd/MM/yyyy ); Result: ----------- 06/06/2015

Chriz L · Answer

Thank you for the quick answer. I get overload error on .ToString( hh:mm:ss tt)

Manas Mohapatra · Answer

Try below code: insDate.Text = ds.Tables[0].Rows[0][InsDate].ToString( hh:mm:ss tt ); Output: ------------- 12:00:00 PM