Textbox TextMode is Date

Question

i try retrive data from db-(sql-server) but im can't fill textbox becusee

TextMode = "Date"

my field in db is DateTime

string transDate = dr["TransDate"].ToString();
txtTransDate.Text = string.Format("{0:dd/MM/yyyy}", dr["TransDate"].ToString());


 <asp:TextBox ID="txtTransDate" runat="server" TextMode="Date"
                                            CssClass="form-control"></asp:TextBox>

Answer 1

you can try below code

var date=DateTime.Parse(dr["TransDate"].ToString());
txtTransDate.Text=date.ToString("dd.MM.yyyy);