Formats for DateTime.ToString() in ASP.Net

Firuz

SOLVED CLOSED ACTIVE ANSWERED
User: Firuz
Posted: on Sep 29, 2016 08:29 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2902

RASPISVR ID IDENTITY

Hi! I have table to name info:

Id	Person	TimeRecypt
1	Rustam	2016-09-29 15:00:00.000
2	Karomatullo	2016-09-29 08:00:00.000
3	Asror	2016-09-29 11:30:00.000

But I want get only time from sql.

I used below code:

private DataTable Getclient(int id)
        {
            DataTable dt = new DataTable();
            using (SqlConnection con = new SqlConnection(UserData))
            {
        SqlCommand cmd = new SqlCommand("SELECT PERSON,SANA FROM INFO", con);
                con.Open();
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter d = new SqlDataAdapter(cmd);
                d.Fill(dt);
                con.Close();
            }
            return dt;
        }
private void SetColors()
        {
            foreach (DataRow dr in client.Rows)
            {
                DateTime timeRecipt = Convert.ToDateTime(dr["SANA"]);
                string day = timeRecipt.DayOfWeek.ToString();
                string tim = timeRecipt.ToString("hh:mm");
                int index = 1;
                int ColIndex = 1;
                foreach (DataColumn item in time.Columns)
                {
                    if (item.ColumnName == day)
                    {
                        ColIndex = index;
                        break;                        
                    }
                    index++;
                     
                }

                foreach (GridViewRow row in Grid.Rows)
                {
                    row.Style.Add("background-color","#99FF99");
                    string cell = row.Cells[ColIndex].Text;
                    if (cell == tim)
                    {
                        row.Cells[ColIndex].Style.Add("background-color", "Red");
                    }
                    Label11.Text = tim + " " + cell;
                }
            }
        }

It’s worked wrong.

Sometimes show :

15:00

08:00

11:30

Sometimes show :

3:00

08:00

11:30

I want always show:

15:00

15:30

Not show:

3:00

3:30

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 29, 2016 08:44 AM
Modified: on Sep 29, 2016 09:07 AM
Report

Hi Firuz,

Change your select query like below.

SELECT PERSON,SANA,CONVERT(VARCHAR(8),SANA,108) SANATIME FROM INFO

Code

DateTime timeRecipt = Convert.ToDateTime(dr["SANA"]);
string day = timeRecipt.DayOfWeek.ToString();
string tim = dr["SANATIME"].ToString();

Or as per you code use HH:mm

string tim = timeRecipt.ToString("HH:mm");

Below are the Formats for DateTime.ToString()

DateTime dateTime = DateTime.Now;
string strDate = "";
strDate = dateTime.ToString("MM/dd/yyyy");                              // 09/29/2016 
strDate = dateTime.ToString("dddd, dd MMMM yyyy");                      // Thursday, 29 September 2016
strDate = dateTime.ToString("dddd, dd MMMM yyyy HH:mm");                // Thursday, 29 September 2016 20:15
strDate = dateTime.ToString("dddd, dd MMMM yyyy hh:mm tt");             // Thursday, 29 September 2016 08:15 PM
strDate = dateTime.ToString("dddd, dd MMMM yyyy H:mm");                 // Thursday, 29 September 2016 20:15
strDate = dateTime.ToString("dddd, dd MMMM yyyy h:mm tt");              // Thursday, 29 September 2016 8:15 PM
strDate = dateTime.ToString("dddd, dd MMMM yyyy HH:mm:ss");             // Thursday, 29 September 2016 20:15:27
strDate = dateTime.ToString("MM/dd/yyyy HH:mm");                        // 09/29/2016 20:15
strDate = dateTime.ToString("MM/dd/yyyy hh:mm tt");                     // 09/29/2016 08:15 PM
strDate = dateTime.ToString("MM/dd/yyyy H:mm");                         // 09/29/2016 20:15
strDate = dateTime.ToString("MM/dd/yyyy h:mm tt");                      // 09/29/2016 8:15 PM
strDate = dateTime.ToString("MM/dd/yyyy HH:mm:ss");                     // 09/29/2016 20:15:27
strDate = dateTime.ToString("MMMM dd");                                 // September 29
strDate = dateTime.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK");  // 2016-09-29T20:15:27.9811973-07:00    
strDate = dateTime.ToString("ddd, dd MMM yyyy HH':'mm':'ss 'GMT'");     // Thu, 29 Sep 2016 20:15:27 GMT
strDate = dateTime.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss");           // 2016-09-29T20:15:27
strDate = dateTime.ToString("HH:mm");                                   // 20:15
strDate = dateTime.ToString("hh:mm tt");                                // 08:15 PM
strDate = dateTime.ToString("H:mm");                                    // 20:15
strDate = dateTime.ToString("h:mm tt");                                 // 8:15 PM
strDate = dateTime.ToString("HH:mm:ss");                                // 20:15:27
strDate = dateTime.ToString("yyyy'-'MM'-'dd HH':'mm':'ss'Z'");          // 2016-09-29 20:15:27Z
strDate = dateTime.ToString("dddd, dd MMMM yyyy HH:mm:ss");             // Thursday, 29 September 2016 20:15:27
strDate = dateTime.ToString("yyyy MMMM");                               // 2016 September

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Formats for DateTime.ToString() in ASP.Net

Company

Explore

Follow us

Contact Us