SqlConnection con = new SqlConnection("Server=Darkover;uid=sa;pwd=Password1;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(@"C:\winnt\Gone Fishing.BMP", 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();
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(@"C:\winnt\Gone Fishing.BMP", 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();
解决方案 »
- 更改GridView标头字体
- 字符串都不能存了。。。。。。
- 求救!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 一个简单的问题 求解答(在线)
- 问一个用repeater显示报表的问题?
- DataGrid更新记录?
- 初学学习ASP.NET应具备的基础什么什么?
- 请问:自动生成的web控件如何处理级联事件
- 为什么我的虚拟主机用ASP.NET就不能上传呢,asp就可以
- WEBFORM从基类中继承后,就无法从vs.net打开它的窗体进行可视化属性设置,怎么办?
- 我想控制checkboxlist输出时的布局,改怎么做?
- 急啊!用TABLE自动生成得DropDownList和CheckBoxList控件,如何能取道到被选中得值???
关于SqlCommandBuilder的用法,你可以查看一下帮助
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.2052/cpref/html/frlrfsystemdatasqlclientsqlcommandbuilderclasstopic.htm
SqlCommandBuilder的三个重要方法
GetInsertcommand(),GetUpdateCommand(),GetDeleteCommand()好好给介绍一下。