ASP.NET学习基础六：用DATASET进行数据添加

string MyConnString = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=dianxinkapin;Data Source=new";

string strSel = "select * from comeout";

DataSet ds = new DataSet();

OleDbConnection MyConn = new OleDbConnection(MyConnString);

OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);

MyAdapter.Fill(ds,"comeout");

DataRow dr = ds.Tables[0].NewRow();

dr["出库编号"]  = 6;

dr["出库日期"]  = "2003-6-6";

dr["卡类"]  = "新卡";

dr["数量"]  = 1000;

ds.Tables[0].Rows.Add(dr);

datagrid1.DataSource = ds;

datagrid1.DataMember = "comeout";

datagrid1.DataBind();