C # how to read the BLOB value from SQL. . . Who can teach me. . .

流浪小夏

When I write it, I use
private void button2_Click (object sender, System.EventArgs e)
{
try
{
byte [] photo = GetPhoto (@ "E:\Documents and Settings\wys\My Documents\15.jpg");
SqlConnection con = new SqlConnection ("server = .; uid = sa; pwd =; database = PJ;");
con.Open ();
SqlCommand com = new SqlCommand ("INSERT INTO TABLE1 (edd) Values ​​('" + photo + "')", con);
com.ExecuteNonQuery ();
con.Close ();
}
catch (Exception x)
{
MessageBox.Show (x.Message);
}

}



public static byte [] GetPhoto (string filePath)
{
FileStream fs = new FileStream (filePath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader (fs);

byte [] photo = br.ReadBytes ((int) fs.Length);

br.Close ();
fs.Close ();
return photo;
}





Who can write the read out picture

I beg you here

流浪小夏

Why is nobody here? . . Let me push it myself. . Please

wenmy715

Read from SqlServer and display it
Add the following code where you need to display the picture:
<asp: image id = "imgPhoto" runat = "server" ImageUrl = "ShowPhoto.aspx"> </ asp: image>

ShowPhoto.aspx body code:
private void Page_Load (object sender, System.EventArgs e)
{
     if (! Page.IsPostBack)
     {
                SqlConnection conn = new SqlConnection ()
                conn.ConnectionString = "Data Source = localhost; Database = test; User Id = sa; Pwd = sa";
                
                string strSql = "select * from test where id = 2"; // Assuming here to get an image with id 2
                SqlCommand cmd = new SqlCommand ()
                reader.Read ();
                Response.ContentType = "application / octet-stream";
                Response.BinaryWrite ((Byte []) reader ["FImage"]);
                Response.End ();
                reader.Close ();
     }
}

wenmy715

reader is defined by DataReader

流浪小夏

Help me see what's wrong. . . How to write if you want to display on Image

CS0234: The type or namespace name "Global" does not exist in the class or namespace "System.Web.UI.WebControls.Image" (are you missing an assembly reference?)

冷雨雪

After converting to byte type, it is stored in the Image field.
byte [] imagebytes = null;
FileStream fs = new FileStream (Image_path, FileMode.Open);
BinaryReader br = new BinaryReader (fs);
imagebytes = br.ReadBytes (br.Length);
SqlParameter parInput22 = cmd.Parameters.Add ("@ 员 图片", SqlDbType.Image);
parInput22.Direction = ParameterDirection.Input;
cmd.Parameters ["@ 员 图片"] .Value = imagebytes;
cmd.ExecuteNonQuery ();

alex79

mark

cmc_1000

mark