this is my approach but it doesn't work what i need to change in my code ??
foreach (GridViewRowInfo rowInfo in radGridView1.Rows)
{
MemoryStream stream = new MemoryStream();
foreach (GridImageCellElement cell in rowInfo.Cells)
{
if (cell.Image != null)
{
Image image1 = GetImageFromBytes(rowInfo.Cells[2].Value as byte[]);
image1.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
}
}
byte[] pic = stream.ToArray();
sql1 = "INSERT INTO customersdocs([custnumber],[custname],[number],[name],[doc])VALUES(@custnumber,@custname,@number,@name,@doc)";
cm.CommandText = sql1;
cm.Parameters.Clear();
cm.Parameters.AddWithValue("@custnumber", radLabel4.Text);
cm.Parameters.AddWithValue("@custname", radTextBox3.Text);
cm.Parameters.AddWithValue("@number", rowInfo.Cells[0].Value.ToString());
cm.Parameters.AddWithValue("@name", rowInfo.Cells[1].Value.ToString());
cm.Parameters.AddWithValue("@doc", pic);
cm.ExecuteNonQuery();
}