data base to date time picker value not displayed

Question

i am using vs2015  my database table columns is regnonamedobimage 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?

Rafnas T P · Answer

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 Mady · Answer

error message displayed on search time...... string type not converted

Rafnas T P · Answer

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 Mady · Answer

dob data type is varchar (50)

Rafnas T P · Answer

try this datetimepicke.Value= Convert.DateTime(DS.Tables[0].Rows[0].ItemArray[ 7 ].ToString()); red 7 is your dob field column nomber