passing a Datetime from SQL to an asp textbox but getting different result

Question

I am passing a DateTime value from SQL Table to a Textbox in ASP.Net using

<asp:TextBox ID="dateTxt" runat="server" Text='<%# Eval("date").ToString()%>' class="form-control"></asp:TextBox>

The Value in SQL is 2023-02-08 16:01:49.153

But shows in the textbox as 2/8/2023 09:07:13 PM

I want it to show as the exact SQL value.

This is how I get the value from the Database

SqlCommand cmd = new SqlCommand("SELECT *   FROM   ThisTable where stage = 'pending'", con)
                    {
                        CommandType = CommandType.Text
                    };
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();

buddemat · Accepted Answer · 2023-02-11 23:51:33Z

1

I have used this it works for me

Text='<%# Eval("date").ToString("yyyy-MM-dd hh:mm:ss")%'

edited Feb 11, 2023 at 23:51

buddemat

5,33016 gold badges37 silver badges61 bronze badges

answered Feb 9, 2023 at 9:16

Praveen Mishra

895 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Md. Suman Kabir · Accepted Answer · 2023-02-09 03:45:33Z

0

Try this :

Eval("date").ToString("yyyy-MM-dd hh:mm:ss")

answered Feb 9, 2023 at 3:45

Md. Suman Kabir

5,4515 gold badges29 silver badges45 bronze badges

1 Comment

toly P Over a year ago

I tried that but I needed the milliseconds and when I added the fff for milliseconds it would just put "000". If figured out how to do it though. Thank you for trying. I posted the answer.

toly P · Accepted Answer · 2023-02-09 03:57:46Z

0

I needed to add

Text='<%# Eval("date", "{0:yyyy-MM-dd HH:mm:ss.fff}") %>'

and that worked for me.

answered Feb 9, 2023 at 3:57

toly P

627 bronze badges

Collectives™ on Stack Overflow

passing a Datetime from SQL to an asp textbox but getting different result

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related