Using C # in SQL Server2000 Access Image for Window

private void Form1_Load (object sender, System.EventArgs e) {string connString = ""; connString = @ "Persist Security Info = False; User ID = sa; Initial Catalog = work; Data Source = (local)"; this.sqlConnection1 .ConnectionString = connString; this.FillListBox (); if (this.listBox1.Items.Count> 0) this.listBox1.SetSelected (0, true);} private void FillListBox () {this.listBox1.SelectedIndexChanged - = new System .EventHandler (this.listBox1_SelectedIndexChanged); string comm = "select id, name from table1"; System.Data.DataTable dt = new DataTable ( "imgTable"); this.sqlCommand1.CommandType = System.Data.CommandType.Text; this .sqlCommand1.CommandText = comm; this.sqlCommand1.Connection = this.sqlConnection1; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter (this.sqlCommand1); this.sqlConnection1.Open (); da. Fill (DT); this.sqlConnection1.close (); this.listbox1.datasource = dt; this.listbox1.displaymember = "name"; this.listbox1.valueme MBER = "ID"; this.listbox1.refresh (); this.listbox1.selected IndexChanged = new system.eventhandler (this.listbox1_selected);}

// SQL server2000 saved image display Picture buffByte = null in the private void listBox1_SelectedIndexChanged (object sender, System.EventArgs e) {byte []; string comm = @ "select img from table1 where id =" this.listBox1 .SelectedValue; this.sqlCommand1 = new System.Data.SqlClient.SqlCommand (); this.sqlCommand1.CommandType = System.Data.CommandType.Text; this.sqlCommand1.CommandText = comm; this.sqlCommand1.Connection = this.sqlConnection1; THIS.SQLCONNECTION1.Open (); system.data.sqlclcent.sqlDataReader rd = this.sqlcommand1.executeReader (); while (rd.read ()) {buffbyte = ((byte []) RD [0]);} rd .Close (); this.sqlConnection1.close (); // put the image array array into memory current system.io.MemoryStream ms = new system.io.MemoryStream (BUFFBYTE); // Establish BitMap System through the stream .Drawing.Bitmap bmp = new Bitmap (ms); this.pictureBox1.Image = bmp;} // save the image to the image field SQL server2000 private void button2_Click_1 (object sender, System.EventArgs e) {string pathName; if (this.openfiledialog1.showdia log () == System.Windows.Forms.DialogResult.OK) {pathName = this.openFileDialog1.FileName; System.Drawing.Image img = System.Drawing.Image.FromFile (pathName); this.pictureBox1.Image = img; // Read the image into byte arrays System.IO.FileStream fs = new system.io.filestream (pathname, system.io.filemode.open, system.io.filecess.read; byte [] buffbyte = new Byte [fs.length]; fs.read (buffbyte, 0, (int) fs.length); fs.close (); fs = null; // Established Command Command String Comm = @ "INSERT INTO TABLE1 (IMG, NAME) VALUES (@ img, @ name) "; this.sqlcommand1 = new system.data.sqlclient.sqlcommand ();

this.sqlCommand1.CommandType = System.Data.CommandType.Text; this.sqlCommand1.CommandText = comm; this.sqlCommand1.Connection = this.sqlConnection1; // create Parameter this.sqlCommand1.Parameters.Add ( "@ img", System .Data.sqldbtype.Image); this.sqlcommand1.parameters [0] .value = buffbyte; this.sqlcommand1.parameters.add ("@ name", system.data.sqldbtype.varchar); this.sqlcommand1.parameters [1 ] .Value = pathname.substring (Pathname.lastIndexof ("//") 1); try {this.sqlConnection1.Open (); this.sqlcommand1.executenonury (); this.sqlConnection1.close ();} catch System.Exception EE) {MessageBox.show (Ee.Message);} buffbyte = null; this.FillListBox ();}}

// private void meneuitem1_click (object sender, system.eventargs e) // {// this.savefiledialog1.filename = (system.data.datarowview) this.listbox1.selectedItem) [1] .tostring (); // this .savefiledialog1.filter = "jpg (* .jpg) | * .jpg | gif (* .gif) | * .gif | Bitmap (* .bmp) | * .bmp"; // if (this.savefiledialog1.showdialog () == System.Windows.Forms.DialogResult.OK) // this.pictureBox1.Image.Save (this.saveFileDialog1.FileName); //} //// private void menuItem2_Click (object sender, System.EventArgs e) // {// System.Drawing.Image img = this.pictureBox1.Image; // System.Drawing.Image.GetThumbnailImageAbort myCallback = new System.Drawing.Image.GetThumbnailImageAbort (ThumbnailCallback); //// System.Drawing.Image img1 = img.GetThumbnailImage (System.Convert.ToInt32 (img.Width * 0.5), System.Convert.ToInt32 (img.Height * 0.5), myCallback, IntPtr.Zero); // this.pictureBox1.Image = img1; / /} /} // public bool thumbnailcallback () // {// Return false; ///} /// Private Void MenuItem3_click (Object Sender, System.Eventa rgs e) // {// System.Drawing.Image img = this.pictureBox1.Image; // System.Drawing.Image.GetThumbnailImageAbort myCallback = new System.Drawing.Image.GetThumbnailImageAbort (ThumbnailCallback); //// System. Drawing.Image img1 = img.GetThumbnailImage (System.Convert.ToInt32 (img.Width * 1.5), System.Convert.ToInt32 (img.Height * 1.5), myCallback, IntPtr.Zero); // this.pictureBox1.Image = IMG1; //}}}}}