⑵ 添加名称空间引用

using System.Data;

using System.Data.SqlClient;

using System.IO;

⑶ 添加字段声明

private string connString="server=localhost; integrated security=sspi; database=pubs";

SqlConnection conn;

SqlDataAdapter adapter;

DataSet dataset;

⑷ 在构造函数中添加代码

string sqlstr="select * from pub_info";

conn=new SqlConnection(connString);

adapter=new SqlDataAdapter(sqlstr,conn);

SqlCommandBuilder builder=new SqlCommandBuilder(adapter);

adapter.UpdateCommand=builder.GetUpdateCommand();

dataset=new DataSet();

adapter.Fill(dataset,"pub_info");

//将text1Box1的Text属性绑定到dataset中的pub_info表的pr_info字段

this.textBox1.DataBindings.Add(new Binding("Text",dataset,"pub_info.pr_info"));

for(int i=0;i

{

this.listBox1.Items.Add(dataset.Tables[0].Rows[i][0]);

}

⑸ 添加调用的方法

private void ShowImage()

{

byte[] bytes= (byte[])dataset.Tables[0].Rows[this.listBox1.SelectedIndex][1];

MemoryStream memStream=new MemoryStream(bytes);

try

{

Bitmap myImage = new Bitmap(memStream);

this.pictureBox1.Image= myImage;

}

catch

{

this.pictureBox1.Image=null;

}

}

⑹ 添加“更换图片”的Click事件代码

private void buttonUpdateImage_Click(object sender, System.EventArgs e)

{

OpenFileDialog openFileDialog1=new OpenFileDialog();

openFileDialog1.ShowDialog();

if (openFileDialog1.FileName.Trim()!="")

{

Stream myStream = openFileDialog1.OpenFile();

int length=(int)myStream.Length;

byte[] bytes=new byte[length];

myStream.Read(bytes,0,length);

myStream.Close();

dataset.Tables[0].Rows[this.listBox1.SelectedIndex][1] =bytes;

ShowImage();

}

}

⑺ 添加“移除图片”的Click事件代码

private void buttonMoveImage_Click(object sender, System.EventArgs e)

{

byte[] bytes= System.Text.Encoding.Unicode.GetBytes("");

dataset.Tables[0].Rows[this.listBox1.SelectedIndex][1]=

bytes;

ShowImage();

}

⑻ 添加“保存更改”的Click事件代码

private void buttonSave_Click(object sender, System.EventArgs e)

{

adapter.Update(dataset,"pub_info");

MessageBox.Show("保存成功");

}

⑼ 添加listBox1的SelectedIndexChanged事件代码

private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)

{

ShowImage();

this.BindingContext[dataset,"pub_info"].Position

=this.listBox1.SelectedIndex;

}

(10) 运行。

可以更换图片，也可以直接修改textBox1中的内容。