try
{
int n = Convert.ToInt32(Interaction.InputBox("Enter sno:", "Search", "20", 100, 100));
DataRow drow;
drow = ds.Tables[0].Rows.Find(n);
if (drow != null)
rno = ds.Tables[0].Rows.IndexOf(drow);
textBox1.Text = drow[0].ToString();
textBox2.Text = drow[1].ToString();
textBox3.Text = drow[2].ToString();
pictureBox1.Image = null;
if (drow[3] != System.DBNull.Value)
photo_aray = (byte[])drow[3];
MemoryStream ms = new MemoryStream(photo_aray);
pictureBox1.Image = Image.FromStream(ms);
}
else
MessageBox.Show("Record Not Found");
catch(Exception ex)
MessageBox.Show(ex.Message.ToString());