用C#把图片存到SQL server数据库中

  1//在SQL中建一个库为:sjData 一人表:mytb  字段:"pc" 类型为:image  ,"name"  类型为:text   
  2
  3using System; 
  4using System.Drawing; 
  5using System.Collections; 
  6using System.ComponentModel; 
  7using System.Windows.Forms; 
  8using System.Data; 
  9using System.Text; 
 10using System.IO; 
 11using System.Data.SqlClient; 
 12namespace 记取图片 
 13{ 
 14   /**//// <summary> 
 15   /// Form1 的摘要说明。 
 16   /// </summary> 
 17   public class Form1 : System.Windows.Forms.Form 
 18   { 
 19      string myname; 
 20      DateTime mydt=DateTime.Now; 
 21      private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; 
 22      private 记取图片.DataSet1 dataSet11; 
 23      private System.Windows.Forms.Button button1; 
 24      private System.Windows.Forms.Button button2; 
 25      private System.Windows.Forms.Button button3; 
 26      private System.Windows.Forms.TextBox textBox1; 
 27      private System.Windows.Forms.PictureBox pictureBox1; 
 28      private System.Windows.Forms.OpenFileDialog ofdSelectPic; 
 29      private System.Data.SqlClient.SqlConnection sqlConnection1; 
 30      private System.Data.SqlClient.SqlCommand sqlSelectCommand1; 
 31      private System.Data.SqlClient.SqlCommand sqlInsertCommand1; 
 32      private System.Data.SqlClient.SqlCommand sqlUpdateCommand1; 
 33      private System.Data.SqlClient.SqlCommand sqlDeleteCommand1; 
 34      private System.Windows.Forms.Label label1; 
 35      private System.Windows.Forms.Button button4; 
 36      private System.Windows.Forms.Button button5; 
 37      private System.Windows.Forms.Button button6; 
 38      /**//// <summary> 
 39      /// 必需的设计器变量。 
 40      /// </summary> 
 41      private System.ComponentModel.Container components = null; 
 42
 43      public Form1() 
 44      { 
 45         // 
 46         // Windows 窗体设计器支持所必需的 
 47         // 
 48         InitializeComponent(); 
 49
 50         // 
 51         // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 
 52         // 
 53      } 
 54
 55      /**//// <summary> 
 56      /// 清理所有正在使用的资源。 
 57      /// </summary> 
 58      protected override void Dispose( bool disposing ) 
 59      { 
 60         if( disposing ) 
 61         { 
 62            if (components != null)  
 63            { 
 64               components.Dispose(); 
 65            } 
 66         } 
 67         base.Dispose( disposing ); 
 68      } 
 69
 70      Windows 窗体设计器生成的代码#region Windows 窗体设计器生成的代码 
 71      /**//// <summary> 
 72      /// 设计器支持所需的方法 - 不要使用代码编辑器修改 
 73      /// 此方法的内容。 
 74      /// </summary> 
 75      private void InitializeComponent() 
 76      { 
 77         this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); 
 78         this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); 
 79         this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); 
 80         this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); 
 81         this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); 
 82         this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); 
 83         this.dataSet11 = new 记取图片.DataSet1(); 
 84         this.pictureBox1 = new System.Windows.Forms.PictureBox(); 
 85         this.button1 = new System.Windows.Forms.Button(); 
 86         this.button2 = new System.Windows.Forms.Button(); 
 87         this.button3 = new System.Windows.Forms.Button(); 
 88         this.textBox1 = new System.Windows.Forms.TextBox(); 
 89         this.ofdSelectPic = new System.Windows.Forms.OpenFileDialog(); 
 90         this.label1 = new System.Windows.Forms.Label(); 
 91         this.button4 = new System.Windows.Forms.Button(); 
 92         this.button5 = new System.Windows.Forms.Button(); 
 93         this.button6 = new System.Windows.Forms.Button(); 
 94         ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); 
 95         this.SuspendLayout(); 
 96         //  
 97         // sqlDataAdapter1 
 98         //  
 99         this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1; 
100         this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1; 
101         this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1; 
102         this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { 
103                                                                             new System.Data.Common.DataTableMapping("Table", "mytb", new System.Data.Common.DataColumnMapping[] { 
104                                                                                                                                                           new System.Data.Common.DataColumnMapping("pc", "pc"), 
105                                                                                                                                                           new System.Data.Common.DataColumnMapping("name", "name")})}); 
106         this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1; 
107         //  
108         // sqlDeleteCommand1 
109         //  
110         this.sqlDeleteCommand1.CommandText = "DELETE FROM mytb WHERE (name = @Original_name)"; 
111         this.sqlDeleteCommand1.Connection = this.sqlConnection1; 
112         this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null)); 
113         //  
114         // sqlConnection1 
115         //  
116         this.sqlConnection1.ConnectionString = "workstation id=YLZY;packet size=4096;user id=feiche2004;pwd=6160258;data source=Y" + 
117            "LZY;persist security info=False;initial catalog=sjData"; 
118         //  
119         // sqlInsertCommand1 
120         //  
121         this.sqlInsertCommand1.CommandText = "INSERT INTO mytb(pc, name) VALUES (@pc, @name); SELECT pc, name FROM mytb WHERE (" + 
122            "name = @name)"; 
123         this.sqlInsertCommand1.Connection = this.sqlConnection1; 
124         this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pc", System.Data.SqlDbType.VarBinary, 2147483647, "pc")); 
125         this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.NVarChar, 50, "name")); 
126         //  
127         // sqlSelectCommand1 
128         //  
129         this.sqlSelectCommand1.CommandText = "SELECT pc, name FROM mytb"; 
130         this.sqlSelectCommand1.Connection = this.sqlConnection1; 
131         //  
132         // sqlUpdateCommand1 
133         //  
134         this.sqlUpdateCommand1.CommandText = "UPDATE mytb SET pc = @pc, name = @name WHERE (name = @Original_name); SELECT pc, " + 
135            "name FROM mytb WHERE (name = @name)"; 
136         this.sqlUpdateCommand1.Connection = this.sqlConnection1; 
137         this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pc", System.Data.SqlDbType.VarBinary, 2147483647, "pc")); 
138         this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.NVarChar, 50, "name")); 
139         this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null)); 
140         //  
141         // dataSet11 
142         //  
143         this.dataSet11.DataSetName = "DataSet1"; 
144         this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN"); 
145         //  
146         // pictureBox1 
147         //  
148         this.pictureBox1.Location = new System.Drawing.Point(16, 8); 
149         this.pictureBox1.Name = "pictureBox1"; 
150         this.pictureBox1.Size = new System.Drawing.Size(264, 168); 
151         this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; 
152         this.pictureBox1.TabIndex = 0; 
153         this.pictureBox1.TabStop = false; 
154         //  
155         // button1 
156         //  
157         this.button1.Location = new System.Drawing.Point(24, 200); 
158         this.button1.Name = "button1"; 
159         this.button1.Size = new System.Drawing.Size(120, 24); 
160         this.button1.TabIndex = 1; 
161         this.button1.Text = "从文件添加图片"; 
162         this.button1.Click += new System.EventHandler(this.button1_Click); 
163         //  
164         // button2 
165         //  
166         this.button2.Location = new System.Drawing.Point(24, 224); 
167         this.button2.Name = "button2"; 
168         this.button2.Size = new System.Drawing.Size(120, 24); 
169         this.button2.TabIndex = 2; 
170         this.button2.Text = "从库中读出显示"; 
171         this.button2.Click += new System.EventHandler(this.button2_Click); 
172         //  
173         // button3 
174         //  
175         this.button3.Location = new System.Drawing.Point(24, 248); 
176         this.button3.Name = "button3"; 
177         this.button3.Size = new System.Drawing.Size(120, 24); 
178         this.button3.TabIndex = 3; 
179         this.button3.Text = "从pictureBox中抓取"; 
180         this.button3.Click += new System.EventHandler(this.button3_Click); 
181         //  
182         // textBox1 
183         //  
184         this.textBox1.Location = new System.Drawing.Point(16, 288); 
185         this.textBox1.Name = "textBox1"; 
186         this.textBox1.Size = new System.Drawing.Size(96, 21); 
187         this.textBox1.TabIndex = 4; 
188         this.textBox1.Text = "1"; 
189         //  
190         // label1 
191         //  
192         this.label1.Location = new System.Drawing.Point(208, 288); 
193         this.label1.Name = "label1"; 
194         this.label1.Size = new System.Drawing.Size(48, 24); 
195         this.label1.TabIndex = 5; 
196         this.label1.Text = "label1"; 
197         //  
198         // button4 
199         //  
200         this.button4.Location = new System.Drawing.Point(144, 288); 
201         this.button4.Name = "button4"; 
202         this.button4.Size = new System.Drawing.Size(48, 24); 
203         this.button4.TabIndex = 7; 
204         this.button4.Text = "<"; 
205         this.button4.Click += new System.EventHandler(this.button4_Click); 
206         //  
207         // button5 
208         //  
209         this.button5.Location = new System.Drawing.Point(256, 288); 
210         this.button5.Name = "button5"; 
211         this.button5.Size = new System.Drawing.Size(48, 24); 
212         this.button5.TabIndex = 8; 
213         this.button5.Text = ">"; 
214         this.button5.Click += new System.EventHandler(this.button5_Click); 
215         //  
216         // button6 
217         //  
218         this.button6.Location = new System.Drawing.Point(144, 200); 
219         this.button6.Name = "button6"; 
220         this.button6.Size = new System.Drawing.Size(144, 24); 
221         this.button6.TabIndex = 9; 
222         this.button6.Text = "button6"; 
223         this.button6.Click += new System.EventHandler(this.button6_Click); 
224         //  
225         // Form1 
226         //  
227         this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); 
228         this.ClientSize = new System.Drawing.Size(328, 325); 
229         this.Controls.Add(this.button6); 
230         this.Controls.Add(this.button5); 
231         this.Controls.Add(this.button4); 
232         this.Controls.Add(this.label1); 
233         this.Controls.Add(this.textBox1); 
234         this.Controls.Add(this.button3); 
235         this.Controls.Add(this.button2); 
236         this.Controls.Add(this.button1); 
237         this.Controls.Add(this.pictureBox1); 
238         this.Name = "Form1"; 
239         this.Text = "Form1"; 
240         this.Load += new System.EventHandler(this.Form1_Load); 
241         ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); 
242         this.ResumeLayout(false); 
243
244      } 
245      #endregion 
246
247      /**//// <summary> 
248      /// 应用程序的主入口点。 
249      /// </summary> 
250      [STAThread] 
251      static void Main()  
252      { 
253         Application.Run(new Form1()); 
254      } 
255
256      private void button1_Click(object sender, System.EventArgs e) 
257      { 
258         Stream ms; 
259          
260         byte[] picbyte; 
261         try 
262         { 
263
264            if(ofdSelectPic.ShowDialog()==DialogResult.OK) 
265            { 
266               if((ms=ofdSelectPic.OpenFile())!=null) 
267               { 
268                   
269                  picbyte=new byte[ms.Length]; 
270                  ms.Position=0; 
271                  ms.Read(picbyte,0,Convert.ToInt32(ms.Length)); 
272                   
273pictureBox1.Image=Image.FromFile(ofdSelectPic.FileName.ToString()); 
274                  dataSet11.Clear(); 
275                  sqlDataAdapter1.Fill(dataSet11,"mytb"); 
276                  DataRow myRow; 
277                  myRow=dataSet11.Tables["mytb"].NewRow(); 
278                  myRow["pc"]=picbyte; 
279                
280                  myRow["name"]=mydt.Month.ToString()+mydt.Day.ToString()+mydt.Hour.ToString()+mydt.Minute.ToString()+mydt.Second.ToString()+mydt.Millisecond.ToString(); 
281                  dataSet11.Tables["mytb"].Rows.Add(myRow); 
282                
283                  sqlDataAdapter1.Update(dataSet11); 
284  label1.Text=this.CurRow(dataSet11,int.Parse(textBox1.Text)); 
285                  //ms.Close(); 
286               } 
287            } 
288         } 
289         catch(Exception me) 
290         { 
291            MessageBox.Show(me.Message); 
292         } 
293      } 
294
295      private void button2_Click(object sender, System.EventArgs e) 
296      { 
297         dataSet11.Clear(); 
298         sqlDataAdapter1.Fill(dataSet11,"mytb"); 
299          
300         try 
301         { 
302          
303            //picbyte=new byte[(dataSet11.Tables["mytb"].Rows[int.Parse(textBox1.Text)]["pc"].ToString()).Length]; 
304            MemoryStream ms=new MemoryStream((byte[])dataSet11.Tables["mytb"].Rows[(int.Parse(textBox1.Text)-1)]["pc"]); 
305            //MessageBox.Show();    
306          
307            pictureBox1.Image=Image.FromStream(ms); 
308            //ms.Close(); 
309            label1.Text=this.CurRow(dataSet11,int.Parse(textBox1.Text)); 
310         } 
311         catch(Exception me) 
312         { 
313            MessageBox.Show(me.Message );} 
314      } 
315
316      private void button3_Click(object sender, System.EventArgs e) 
317      { 
318            MemoryStream ms=new MemoryStream(); 
319         byte[] picbyte; 
320         //dim ms as new io.memorystream() 
321    
322         //ms=new MemoryStream(6000); 
323         DateTime mydt=DateTime.Now; 
324         pictureBox1.Image.Save(ms,pictureBox1.Image.RawFormat); 
325         picbyte=new byte[ms.Length]; 
326         ms.Position=0; 
327         ms.Read(picbyte,0,Convert.ToInt32(ms.Length)); 
328         sqlDataAdapter1.Fill(dataSet11,"mytb"); 
329         //MessageBox.Show(picbyte[1].ToString()+picbyte[0].ToString()+picbyte[1].ToString()+picbyte[2].ToString()); 
330         DataRow myRow; 
331         myRow=dataSet11.Tables["mytb"].NewRow(); 
332         myRow["pc"]=picbyte; 
333         myRow["name"]=mydt.Month.ToString()+mydt.Day.ToString()+mydt.Hour.ToString()+mydt.Minute.ToString()+mydt.Second.ToString()+mydt.Millisecond.ToString(); 
334         dataSet11.Tables["mytb"].Rows.Add(myRow); 
335         sqlDataAdapter1.Update(dataSet11); 
336         //ms.Close(); 
337       
338 label1.Text=this.CurRow(dataSet11,int.Parse(textBox1.Text)); 
339      } 
340
341      private void Form1_Load(object sender, System.EventArgs e) 
342      { 
343         myname=   mydt.Month.ToString()+mydt.Day.ToString()+mydt.Hour.ToString()+mydt.Minute.ToString()+mydt.Second.ToString()+mydt.Millisecond.ToString(); 
344
345      } 
346      private string CurRow(DataSet ts,int cur) 
347      { 
348       return cur.ToString()+"/"+this.BindingContext[ts,"mytb"].Count.ToString(); 
349      } 
350
351      private void button4_Click(object sender, System.EventArgs e) 
352      { 
353         textBox1.Text=(int.Parse(textBox1.Text)-1).ToString(); 
354         dataSet11.Clear(); 
355         sqlDataAdapter1.Fill(dataSet11,"mytb"); 
356          
357         try 
358         { 
359          
360            //picbyte=new byte[(dataSet11.Tables["mytb"].Rows[int.Parse(textBox1.Text)]["pc"].ToString()).Length]; 
361            MemoryStream ms=new MemoryStream((byte[])dataSet11.Tables["mytb"].Rows[(int.Parse(textBox1.Text)-1)]["pc"]); 
362            //MessageBox.Show();    
363          
364            pictureBox1.Image=Image.FromStream(ms); 
365            //ms.Close(); 
366            label1.Text=this.CurRow(dataSet11,int.Parse(textBox1.Text)); 
367         } 
368         catch(Exception me) 
369         { 
370            MessageBox.Show(me.Message );} 
371      } 
372
373      private void button5_Click(object sender, System.EventArgs e) 
374      { 
375      textBox1.Text=(int.Parse(textBox1.Text)+1).ToString(); 
376         dataSet11.Clear(); 
377         sqlDataAdapter1.Fill(dataSet11,"mytb"); 
378          
379         try 
380         { 
381          
382            //picbyte=new byte[(dataSet11.Tables["mytb"].Rows[int.Parse(textBox1.Text)]["pc"].ToString()).Length]; 
383            MemoryStream ms=new MemoryStream((byte[])dataSet11.Tables["mytb"].Rows[(int.Parse(textBox1.Text)-1)]["pc"]); 
384            //MessageBox.Show();    
385          
386            pictureBox1.Image=Image.FromStream(ms); 
387            //ms.Close(); 
388            label1.Text=this.CurRow(dataSet11,int.Parse(textBox1.Text)); 
389         } 
390         catch(Exception me) 
391         { 
392            MessageBox.Show(me.Message );} 
393      } 
394
395      private void button6_Click(object sender, System.EventArgs e) 
396      { 
397         //SqlConnection conn=new SqlConnection(@"data source=chenyuming2004\VSdotNET;uid=sa;pwd=cym;database=lhf"); 
398         sqlConnection1.Open(); 
399         //this.sqlInsertCommand1.CommandText = "INSERT INTO mytb(pc, name) VALUES (@pc, @name); SELECT pc, name FROM mytb WHERE (" + 
400         //   "name = @name)"; 
401Stream ms; 
402         SqlCommand cmd=new SqlCommand("insert into mytb values (@pc,'"+this.myname+"')",sqlConnection1); 
403         byte[] ib=new Byte[60000]; 
404         if(ofdSelectPic.ShowDialog()==DialogResult.OK) 
405         { 
406            if((ms=ofdSelectPic.OpenFile())!=null) 
407            { 
408                   
409               //FileStream fs=new FileStream(ofdSelectPic.FileName ,FileMode.Open ,FileAccess.Read ); 
410               ms.Read(ib,0,Convert.ToInt32(ms.Length)); 
411               this.pictureBox1.Image=Image.FromStream(ms); 
412               cmd.Parameters.Add("@pc",SqlDbType.Image,(int)ms.Length); 
413               cmd.Parameters["@pc"].Value=ib; 
414               cmd.ExecuteNonQuery(); 
415               sqlConnection1.Close(); 
416            } 
417            } 
418      } 
419       
420   } 
421} 
422