How to format textbox to date without the time (12:00 AM)

Question

I have a date data from database which the data type is date. I fetch the data from DB using DataSet and populate it to a textbox control. The resulting date contains data and time - 10/3/2016 12:00 AM. What I wanted is this result (10/3/2016 - where 10 is day and 3 is month). below is the snippet of my code: lblIncepDate.Text = ds.Tables[0].Rows[0][IncepDate].ToString(); lblExpDate.Text = ds.Tables[0].Rows[0][ExpDate].ToString(); Hope somebody can share a knowledge.

Amine Touahria · Answer

Replace the last Line with : lblExpDate.Text = Convert.ToDateTime( ds.Tables[0].Rows[0][ExpDate].ToString(dd/MM/yyyy));

Hold On · Answer

Hi @Amine I modified a bit you suggested and did this: txtIncepDate.Text=Convert.ToDateTime(ds.Tables[0].Rows[0][ IncepDate ]).ToString( dd/MM/yyyy CultureInfo.InvariantCulture); and it worked! thanks a lot.

Hold On · Answer

I just don't understand why I got an error of No overload for method 'ToString' takes 2 arguments. To understand my problem better please have a look at my code below on how I populate the data from my sql server to my textboxes: HPAPolicyTablehpaPolicy= new HPAPolicyTable(); HPAPolicyDataAccessviewHPAPolicy= new HPAPolicyDataAccess(); DataSetds= new DataSet(); int count; protected void Page_Load( object senderEventArgse) { if (Session[ Id ]!= null ) { if (!IsPostBack) { hpaPolicy.ID=Convert.ToInt32(Session[ Id ]); ds=viewHPAPolicy.Select_One_HPAPolicy(hpaPolicy); if (ds.Tables[0].Rows.Count>0) { lblPolicyNumber.Text=ds.Tables[0].Rows[0][ PolicyNo ].ToString(); lblIssuanceType.Text=ds.Tables[0].Rows[0][ IssuanceType ].ToString(); lblHPAOption.Text=ds.Tables[0].Rows[0][ HPAOption ].ToString(); lblPolicyHolderName.Text=ds.Tables[0].Rows[0][ PolicyHolderName ].ToString(); lblSubscriberName.Text=ds.Tables[0].Rows[0][ SubscriberName ].ToString(); lblIssuedTime.Text=ds.Tables[0].Rows[0][ IssuedTime ].ToString(); lblIncepDate.Text=ds.Tables[0].Rows[0][ IncepDate ].ToString(dd/MM/yyyy CultureInfo.InvariantCulture); //error lblExpDate.Text=ds.Tables[0].Rows[0][ ExpDate ].ToString(dd/MM/yyyy CultureInfo.InvariantCulture); //error lblHPAPlan.Text=ds.Tables[0].Rows[0][ HPAPlan ].ToString(); txtCoverageBenefit1.Text=ds.Tables[0].Rows[0][ Cov1 ].ToString(); txtCoverageBenefit2.Text=ds.Tables[0].Rows[0][ Cov2 ].ToString(); txtCoverageBenefit3.Text=ds.Tables[0].Rows[0][ Cov3 ].ToString(); txtCoverageBenefit4.Text=ds.Tables[0].Rows[0][ Cov4 ].ToString(); txtCoverageBenefit5.Text=ds.Tables[0].Rows[0][ Cov5 ].ToString(); txtCoverageBenefit6.Text=ds.Tables[0].Rows[0][ Cov6 ].ToString(); txtCoverageBenefit7.Text=ds.Tables[0].Rows[0][ Cov7 ].ToString(); txtCoverageBenefit8.Text=ds.Tables[0].Rows[0][ Cov8 ].ToString(); txtCoverageBenefit9.Text=ds.Tables[0].Rows[0][ Cov9 ].ToString(); txtCoverageBenefit10.Text=ds.Tables[0].Rows[0][ Cov10 ].ToString(); txtCoverageBenefit11.Text=ds.Tables[0].Rows[0][ Cov11 ].ToString(); txtCoverageBenefit11a.Text=ds.Tables[0].Rows[0][ Cov12 ].ToString(); txtCoverageBenefit11b.Text=ds.Tables[0].Rows[0][ Cov13 ].ToString(); txtCoverageBenefit12.Text=ds.Tables[0].Rows[0][ Cov14 ].ToString(); txtCoverageBenefit13.Text=ds.Tables[0].Rows[0][ Cov15 ].ToString(); txtCoverageBenefit14.Text=ds.Tables[0].Rows[0][ Cov16 ].ToString(); txtNetPremium.Text=ds.Tables[0].Rows[0][ NetPremium ].ToString(); txtPercentageDiscount.Text=ds.Tables[0].Rows[0][ DiscountRate ].ToString(); txtDiscount.Text=ds.Tables[0].Rows[0][ DiscountNet ].ToString(); txtTotalPremium.Text=ds.Tables[0].Rows[0][ TotalPremium ].ToString(); lblAgent.Text=ds.Tables[0].Rows[0][ Agent ].ToString(); lblBroker.Text=ds.Tables[0].Rows[0][ Broker ].ToString(); lblDirect.Text=ds.Tables[0].Rows[0][ Direct ].ToString(); lblIssuedDate.Text=ds.Tables[0].Rows[0][ IssuedDate ].ToString(); txtExclussion1.Text=ds.Tables[0].Rows[0][ Exclussion1 ].ToString(); txtExclussion2.Text=ds.Tables[0].Rows[0][ Exclussion2 ].ToString(); txtExclussion3.Text=ds.Tables[0].Rows[0][ Exclussion3 ].ToString(); txtExclussion4.Text=ds.Tables[0].Rows[0][ Exclussion4 ].ToString(); txtExclussion5.Text=ds.Tables[0].Rows[0][ Exclussion5 ].ToString(); txtExclussion6.Text=ds.Tables[0].Rows[0][ ExclussionOthers ].ToString(); } } } else { Response.Redirect( ~/Underwriting/HPA/View-HPA-Policy.aspx ); } }

Midhun T P · Answer

Hi Please have a look at below thread- http://stackoverflow.com/questions/5050102/convert-datetime-to-date-format-dd-mm-yyyy

Hold On · Answer

Hi @Bikesh thanks for the reply. I'm just new in programming. Can you show me how and where to add your suggestion to my current code?

Bikesh Srivastava · Answer

you need to use regex. ( \d { 4 })-( \d { 2 })-( \d { 2 }) ( \d { 2 }):( \d { 2 }):( \d { 2 })

Hold On · Answer

Thanks for the quick reply @Devendra @Ifour and @Amine but still no luck. Here's the error below:

Milan Prajapati · Answer

User ToShortDateString () instead of only ToString (). So your code now looks like lblIncepDate.Text = ds.Tables[0].Rows[0][IncepDate]. ToShortDateString () ; lblExpDate.Text = ds.Tables[0].Rows[0][ExpDate]. ToShortDateString () ;

Devendra Kumar · Answer

try this lblIncepDate.Text = ds.Tables[0].Rows[0][IncepDate]. ToString(  dd/MM/yyyy );