data base to date time picker value not displayed

Legent Mady

i am using vs2015 ,

my database table columns is regno,name,dob,image

my retrive form code is..

if (DS.Tables[0].Rows.Count > 0)

{

textBox2.Text = DS.Tables[0].Rows[0].ItemArray[0].ToString();

textBox3.Text = DS.Tables[0].Rows[0].ItemArray[1].ToString();

comboBox1.Text = DS.Tables[0].Rows[0].ItemArray[3].ToString();

comboBox7.Text = DS.Tables[0].Rows[0].ItemArray[4].ToString();

comboBox2.Text = DS.Tables[0].Rows[0].ItemArray[5].ToString();

comboBox3.Text = DS.Tables[0].Rows[0].ItemArray[6].ToString();

MemoryStream MS = new MemoryStream((byte[])DS.Tables[0].Rows[0]["IMAGE"]);

pictureBox1.Image = new Bitmap(MS);

MessageBox.Show ("SEARCH FINISHED");

}

how to datetime picker to retrive dob values?

5 Replies

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

Rafnas T P9y ago
please check all the dob values in result set are in datetime format, check any null values or empty are there
put your code inside if condition like below
if (!string.IsNullOrEmpty(DS.Tables[0].Rows[0].ItemArray[7].ToString()))
  {
try{
          datetimepicke.Value = Convert.DateTime(DS.Tables[0].Rows[0].ItemArray[7].ToString());
       }catch{}
  }
Legent Mady9y ago
error message displayed on search time......

""string type not converted"
Rafnas T P9y ago
thats ok but in that you will be getting propper datetime format so that in c# code while converting to datetime will not throw any error
Legent Mady9y ago
dob data type is varchar (50)
Rafnas T P9y ago
try this
datetimepicke.Value= Convert.DateTime(DS.Tables[0].Rows[0].ItemArray[7].ToString());
red 7 is your dob field column nomber