Typecasting Problem

Jagjit Saini

HI

datetime _dt;
string ConnectionStr = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;
MySqlDataAdapter da = new MySqlDataAdapter("select curdate(),curtime()", ConnectionStr);
DataTable dt = new DataTable();
da.Fill(dt);
_dt = (DateTime)dt.Rows[0][0];
label5.Text = _dt.ToString("dd/MM/yyyy");
_dt = (DateTime)dt.Rows[0][1]; (Error : specified cast is not valid)

Thanks

6 Replies

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

mangesh shelar15y ago
        If you use Now() you can get both date and time part and then use the formating to seprate the date and time.
            string ConnectionStr = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString;
            MySqlDataAdapter da = new MySqlDataAdapter("SELECT NOW()", ConnectionStr);
            DataTable dt = new DataTable();
            da.Fill(dt);
            DateTime DateVal = DateTime.Parse(dt.Rows[0][0].ToString());

            lbFullDate.Text = DateVal.ToString();
            lbDatePart.Text = DateVal.ToString("dd/MM/yyyy");
            lbTimePart.Text = DateVal.ToString("HH:mm:ss");
0
Jaish Mathews15y ago
Hi,
Use Convert.ToDateTime(). It wil work if the specified cell contains a valid value in date format.

_dt = Convert.ToDateTime(dt.Rows[0][1]);
0
Jagjit Saini15y ago
Hi

Then how can i get .

I want server date & Time separately . If time is 1:10 P.M (India) , i want time as 13:10.

Thanks
0
Jiteendra Sampathirao15y ago
Run this query select curdate(),curtime()..

it will added to _dt = (DateTime)dt.Rows[0][0];
but not to _dt = (DateTime)dt.Rows[0][1];// you cannot use this line of code...
0
Jagjit Saini15y ago
Hi

Error is in this line

_dt = (DateTime)dt.Rows[0][1]; (Error : specified cast is not valid)

Thanks
0
Jiteendra Sampathirao15y ago
Hi,
I think in this line problem is occurring...label5.Text = _dt.ToString("dd/MM/yyyy");
(type casting)
trace every line by using breakpoint...you will come to know where the exact problem is occurs...
0