textbox mode to datetime not working

Question

Hi textbox mode to datetime not working if used it to fetch record date from sqldb rest of data is fetching properly but not date in textbox(mode->>DateTime). Plz help...any other option or how to set textbox properties so that it fetches date from DB

Sanjeeb Lenka · Answer

hi your code looks good. where you are getting exception.

Sunny Sharma · Answer

suggest you to put a breakpoint and check on which line of code the error invokes.

Sunny Sharma · Answer

please share your code what you've tried so far.

Aman Jen · Answer

here's my code protected void Button1_Click(object sender EventArgs e) { BankClassLib Bn2 = new BankClassLib(); DataTable dtn = Bn2.ShowRec(Convert.ToInt32(DP2.SelectedItem.Value)); tbLoanCD.Text = dtn.Rows[0][LN_Code].ToString(); tbLoanTP.Text = dtn.Rows[0][LN_Type].ToString(); tbBorNm.Text = dtn.Rows[0][Bor_N].ToString(); tbCoBorNm.Text = dtn.Rows[0][Co_Bor].ToString(); tbLoanSanc.Text = dtn.Rows[0][LN_Sanc].ToString(); tbLoanDisb.Text = dtn.Rows[0][Tot_LN_Disb].ToString(); tbInrstType.Text = dtn.Rows[0][Int_Typ].ToString(); tbInrstRst.Text = dtn.Rows[0][Int_Rst].ToString(); tbCurtRoi.Text = dtn.Rows[0][Curt_ROI].ToString(); tbCurtEmi.Text = dtn.Rows[0][Curt_EMI].ToString(); tbDisbDate.Text = dtn.Rows[0][Disb_Dt].ToString(); tbDisbAmt.Text = dtn.Rows[0][Disb_Amt].ToString(); tbBnkFavNm.Text = dtn.Rows[0][Chq_Bank].ToString(); tbEMIOvd.Text = dtn.Rows[0][EMI_Ovd].ToString(); tbPrinOut.Text = dtn.Rows[0][Prin_Out].ToString(); tbChqNm.Text = dtn.Rows[0][Chq_Num].ToString(); }

Sanjeeb Lenka · Answer

hi you can directly assign the db value to textbox.