how to get only date from string in c#
  • Vote Up0Vote Down studentstudent
    82.00 Karma
    Hi i using below code for fetch data from sql but date column also along with time how can split time and get just date in c# string.
    SqlDataAdapter sda = new SqlDataAdapter("select Date From tblSale", conn);
    DataTable dt = new DataTable();
    sda.Fill(dt);
    string date= dt.Rows[0]["Date"].ToString();
  • 1 Comment sorted by
  • Vote Up-1Vote Down ithackerithacker
    57.50 Karma Accepted Answer
    use below line at end.
    //date is string variable name here
    date = DateTime.Parse(date).ToShortDateString();
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Login with Facebook
Sign In Apply for Membership

Categories

In this Discussion

Tagged

Top Posters

Optimum Creative