string strQuery = "select Name, Data from tblFiles where userid=@id"; SqlCommand cmd = new SqlCommand(strQuery); cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32 (5248); DataTable dt = GetData(cmd); if (dt != null) { if(dt.Rows[0]["Data"] !=DBNull.Value) { byte[] bytes = (byte[])dt.Rows[0]["Data"]; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); Image1.ImageUrl = "data:image/png;base64," + base64String; } if(dt.Rows[1]["Data"] !=DBNull.Value) { byte[] bytes = (byte[])dt.Rows[2]["Data"]; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); Image2.ImageUrl = "data:image/png;base64," + base64String; } if(dt.Rows[2]["Data"] !=DBNull.Value) { byte[] bytes = (byte[])dt.Rows[2]["Data"]; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); Image3.ImageUrl = "data:image/png;base64," + base64String; } if(dt.Rows[3]["Data"] !=DBNull.Value) { byte[] bytes = (byte[])dt.Rows[3]["Data"]; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); Image4.ImageUrl = "data:image/png;base64," + base64String; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)