How to convert date In Select Btn ??

Abdalla Elawad

10y1.1kVisual Basic .NET

Hi Programmers

Label2.Text = reader.GetString(25);

Label2 above is Date 25 is arrangement in TBL

23 Replies

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

Esakki Muthu10y ago
Hi Abdalla,
Try the below code,
Convert.ToDateTime(MyReader["OutBoundDate"]).ToString("dd/MM/yyyy");
0
Jisny Av10y ago
Hi,
Try this
Label2.Text = reader.GetString(25);
string str = DateTime.Now.Month + "/" + Convert.ToInt16(Label2.Text) + "/" + DateTime.Now.Year;
DateTime dt = Convert.ToDateTime(str);
Label2.Text = dt.ToString("dd/MMM/yyyy");
+1
Tapan Patel10y ago
As you have specific date format, you need to parse it in that way.
Please try below.

DateTime dt=DateTime.ParseExact(reader.GetString(25),"yyyy-MM-dd",cultureinfomation);
+1
Vishal Jadav10y ago
Hi,
Don't convert the date-time and just put the result value as it is and check the value.
Thanks.
+1
Rajeesh Menoth10y ago
Hi,

Try this code :
while (reader.Read())
{
Label2.Text = reader.GetString(26);
}
Put a break point and check what value getting in the following line..
Label2.Text = reader.GetString(25);
+1
Abdalla Elawad10y ago
PLS SEE BELOW
+1
Abdalla Elawad10y ago
I will Check anything Please see the Editing Raws and Arrangement of column in TBL
+1
Vasanth Natarajan10y ago
pls check every column has null or not null, i think that 25th column values is null from DB. so, Pls Check the DB Value for 25th column it should not be null or Char values
+1
Abdalla Elawad10y ago
thank You , below the code
+1
Vishal Jadav10y ago
Hi,
Can you please provide the code ?
Thanks...
+1

Vasanth Natarajan10y ago

Try This....

while (reader.Read()) 
{ 
 TextBox3.Text = Convert.ToDateTime(reader["DateField"]).ToString("yyyy-MM-dd"); 
}

Abdalla Elawad10y ago
Not Run
+1
Vinay Singh10y ago
If your date format in table is2015-08-21. then why you are trying to convert 25 as date
+1
Rajeesh Menoth10y ago
Hi,

Your reader.GetString(25);return empty value. So you need to check it's empty or not before assign to datetime.

Try this code :
DateTime dt = Convert.ToDateTime(reader.GetString(25) == "" ? "01/01/0001" : reader.GetString(25));
or
Label2.Text = reader.GetString(25);

        if (!string.IsNullOrWhiteSpace(Label2.Text))
        {
            DateTime dt = Convert.ToDateTime(reader.GetString(25));
        }
+1
Vasanth Natarajan10y ago
try this..
DateTime? dt = null;
if (Label2.Text.ToString() == "")
{
dt= null;
Label3.Text= "";
}
else
{
dt= Convert.ToDateTime(reader.GetString(25));
Label3.Text= String.Format("{0:yyyy-MM-dd}", dt);
}
+1
Abdalla Elawad10y ago
reader doesn't return data like below label2.Text=reader.Getstring (25); Show error on Exec
+1
Rajeesh Menoth10y ago
Hi,
What value getting on "reader.GetString(25)" ? Is returning any datetime or string value ?
0
Abdalla Elawad10y ago
This Date Format in TBL "2015-08-21"
+1
Vinay Singh10y ago
Hi
Please let me know what the format of date you need
+1
Abdalla Elawad10y ago
No Run Also Error
+1
Vinay Singh10y ago
Hi
As i can understand 25 is a no and you want to convert it into date, to display in label control. Here you have to pass the month or you provide the format of date which you want to display on label control.
DateTime dt = Convert.ToDateTime(reader.GetString(25)+"/01/0001");
Label2.Text= dt.ToString("dd/MM/yyyy");
+1
Abdalla Elawad10y ago
This message display when execute your Code
+1
Midhun Tp10y ago
Hi,
Try this -
DateTime dt = Convert.ToDateTime(reader.GetString(25));
Label2.Text= dt.ToString("dd/MM/yyyy");
+1