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

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=newHPAPolicyTable();
HPAPolicyDataAccessviewHPAPolicy=newHPAPolicyDataAccess();
DataSetds=newDataSet();
intcount;
protectedvoidPage_Load(objectsender,EventArgse)
{
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");
}
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amine Touahria10y ago
Accepted answer
Replace the last Line with : lblExpDate.Text = Convert.ToDateTime( ds.Tables[0].Rows[0]["ExpDate"].ToString("dd/MM/yyyy"));
Jes Sie10y ago
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.
Jes Sie10y ago
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=newHPAPolicyTable();
HPAPolicyDataAccessviewHPAPolicy=newHPAPolicyDataAccess();
DataSetds=newDataSet();
intcount;
protectedvoidPage_Load(objectsender,EventArgse)
{
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 Tp10y ago
Hi,

Please have a look at below thread-
http://stackoverflow.com/questions/5050102/convert-datetime-to-date-format-dd-mm-yyyy
Jes Sie10y ago
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 Srivastava10y ago
you need to use regex.
(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})
Jes Sie10y ago
Thanks for the quick reply @Devendra, @Ifour and @Amine but still no luck. Here's the error below:

Milan Prajapati10y ago

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 Kumar10y ago
try this

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