SQL存取图片(国外英语资料).docVIP

SQL存取图片(国外英语资料) Preparatory work, set up a table in the library Im_Test Im_Info, this table has two fields, respectively Pr_Id (INT), Pr_Info (IMAGE), used to store the graphics number and graphical information. Its syntax is as follows: The CREATE TEALE Im_Info ( Pr_Id INT NULL, Pr_Info IMAGE NULL ) Step 1: insert a record into the table and initialize the PR_INFO field. Its syntax is as follows: INSERT INTO Im_Info VALUES (1, 0xffffff) The second step writes the graphical information to the table. Its syntax is as follows: DECLARE @ptrval varbinary (16) SELECT @ptrval = TEXTPTR (Pr_Info) The FROM Im_Info WHERE Pr_Id = 1 WRITETEXT Im_Text Im_Info @ @ ptrval 0 x624fd543fd... .. With zero x624fd543fd... .. The hexadecimal data for the graph can be obtained through tools such as C, Java, etc. Note that the select into/bulkcopy attribute of this database must be set to True before writing the graphical information, and the syntax is as follows: Use the master Exec sp_dboption Im_Test, select into/bulkcopy, True C # reads the Image data type: (1) the console application demonstrates the insert image Public void InsertIMG () { / / the image to be stored is read as a data flow FileStream fs = new FileStream (@ E: \ c.j pg, filemode.open, fileaccess.read); Byte [] btye2 = new Byte [fs. Length] Fs.read (btye2, 0, convert.toint32 (fs.length)); Fs. The Close (); Using (SqlConnection conn = new SqlConnection (sqlconnstr)) { Conn. The Open (); SqlCommand CMD = new SqlCommand (); CMD. Connection = conn; The cmd.Com mandText = insert into T_Img (imgfile) values (@imgfile); SqlParameter par = new SqlParameter ( @imgfile , sqldbtype.image); / / Par. Value = btye2; CMD. The Parameters. The Add (par); Int t = (int) (CMD. ExecuteNonQuery ()); If (t, , 0) { ( OK... ) } Conn. Close (); } } (2) the console application reads and generates images to the physical location Public void the Read () { Byte [] MyData = new byte [0]; Using (SqlConnection conn = new SqlConnection (sqlconnstr)) {