Hi Tarun,
U r fetching data from database correctly.
I think u have saved image in wrong format plz try below code
write image to byte array
FileStream fs = new FileStream(@"C:\Users\ku102\Pictures\bitmap\usertile36.bmp", FileMode.Open, FileAccess.Read);
byte[] imgbnry = new byte[fs.Length];
fs.Read(imgbnry, 0, imgbnry.Length);
fs.Close();
pass byte array to backend for saving
cmd.Parameters.Add("@img", System.Data.SqlDbType.Image);
cmd.Parameters["@img"].Value= imgbnry;
cmd.ExecuteNonQuery();
good luck ;-)