（在线等待）如何用c#将图片从sqlserver2000存取?

[31533586]

如何将一个自己硬盘中的一个图片存入一个sqlserver中名为dbimage库中image表中？以及如何从中提取出图片并显示到窗体制定的位置？

[31533586]

谢谢上面的各位了！
我先试一试！

[zwztu]

//存入图片
private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection con = new

SqlConnection("Server=yxg;uid=sa;pwd=;database=northwind");
SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages", con);
SqlCommandBuilder MyCB = new SqlCommandBuilder(da);
DataSet ds = new DataSet("MyImages");

da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
FileStream fs = new FileStream(@"E:\winnt\Gone Fishing.jpg",

FileMode.OpenOrCreate, FileAccess.Read);

byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));

fs.Close();

da.Fill(ds,"MyImages");

DataRow myRow;
myRow=ds.Tables["MyImages"].NewRow();

myRow["Description"] = "This would be description text";
myRow["imgField"] = MyData;
ds.Tables["MyImages"].Rows.Add(myRow);
da.Update(ds, "MyImages");

con.Close();
}
//取出图片
private void Button2_Click(object sender, System.EventArgs e)
{
SqlConnection con = new

SqlConnection("Server=yxg;uid=sa;pwd=;database=northwind");
SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages",con);
SqlCommandBuilder MyCB = new SqlCommandBuilder(da);
DataSet ds = new DataSet("MyImages");

byte[] MyData= new byte[0];

da.Fill(ds,"MyImages");
DataRow myRow;
myRow=ds.Tables["MyImages"].Rows[0];

MyData=(byte[])myRow["imgField"];
int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);

FileStream fs = new FileStream(@"E:\winnt\Gone Fishing2.jpg",

FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(MyData, 0,ArraySize);
fs.Close();
}

[tjq_tang]

问题1：
http://www.codeproject.com/cs/database/albumviewer.asp
参见这个例子,看能否给你提示