SQL存取图片.docVIP

SQL′?è?í???.txt????òa??í·?′?′￡?·??òóà?????ú×·?°￡???2??aμà×??oê§è￥á?ê2?′?￡?Dè?ìí??ê?áμè?1??μ￡???è?ìí??ê?·ò?T1??μ￡??D???à×?ìí??ê??óó?1??μ?￡?Dè?°?ó????|?′??è?￡?×?ò×êü?à?2???ó￡???è?°?ó?D??′?Dè?￡?×?ò×êüé?D????￥?￡×?±?1¤×÷￡??ú?aIm_Test?D?¨á￠ò???±íIm_Info￡?′?±í?DóDá???×???￡?·?±e?aPr_Id ￡¨INT￡?￡?Pr_Info (IMAGE)￡?ó?à′′?′￠í?D?±ào??°í?D?D??￠?￡??ó?·¨è???￡o CREATE TEALE Im_Info ( Pr_Id INT NULL ￡? Pr_Info IMAGE NULL ) μúò?2?: íù±í?D2?è?ò?ì?????￡?2￠3?ê??ˉPR_INFO×????￡??ó?·¨è???￡o INSERT INTO Im_Info VALUES ￡¨1 ￡?0xFFFFFFFF￡? μú?t2?íù±í?DD′è?í?D?D??￠?￡??ó?·¨è???￡o DECLARE @@ptrval varbinary(16) SELECT @@ptrval = TEXTPTR(Pr_Info) FROM Im_Info WHERE Pr_Id = 1 WRITETEXT Im_Text.Im_Info @@ptrval 0x624fd543fd?-.. ???D0x624fd543fd?-.. ?aí?D?μ?ê?áù????êy?Y￡??éò?í¨1yC ?￠Javaμè1¤????μ??￡ ×￠òa?úD′è?í?D?D??￠?°±?D??è??′?êy?Y?aμ? select into/bulkcopy ê?D?éè???a True ￡???ó?·¨è???￡o use master exec sp_dboption Im_Test ,select into/bulkcopy ,True C#?áè?Imageêy?YààDí￡o ￡¨1￡?????ì¨ó|ó?3ìDò???Yê?2?è?í??? public void InsertIMG() { //??Dèòa′?′￠μ?í????áè??aêy?Yá÷ FileStream fs = new FileStream(@E:\c.jpg, FileMode.Open,FileAccess.Read); Byte[] btye2 = new byte[fs.Length]; fs.Read(btye2 , 0, Convert.ToInt32(fs.Length)); fs.Close(); using (SqlConnection conn = new SqlConnection(sqlconnstr)) { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = insert into T_Img(imgfile) values(@imgfile); SqlParameter par = new SqlParameter(@imgfile, SqlDbType.Image); par.Value = bt; cmd.Parameters.Add(par); int t=(int)(cmd.ExecuteNonQuery()); if (t 0) { Console.WriteLine(2?è?3é1|); } conn.Close(); } } ￡¨2￡?????ì¨ó|ó?3ìDò???á3?2￠éú3é