Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
Return only date from dataset.
Chriz L
Sep 24 2015 2:40 AM
390
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
Microsoft certification
How to define app id and app secret of facebook