RT解决给分。
解决方案 »
- 跪求大虾····
- 散分300,分享一个比较巧妙实现主题皮肤功能代码
- .net加sql问题,哪位兄弟帮看看
- 奇怪的URLRewriter问题
- 请教:asp.net2.0里面用MultiView与view还有menu结合,作选项卡效果,怎么样让他们结合起来???
- 请高手帮忙看一下这个功能是怎么实现的?急用
- AjaxPro 如何与用户控件同时使用
- 高手请进(急!在线等)
- 关于文件保存的问题
- 前端unicode(十六进制)字符在后端获取乱码
- Eddie005(♂) 暴赱 『零零伍』兄在吗?我想使用您的在线会员列表与统计功能,可是不知道如何用啊,其他的路过的各位也帮我看看吧,谢谢了
- DataSet插入问题!!急啊!
union 啊....
// Create a DataSet with one table, two columns, and ten rows.
DataSet ds = new DataSet("myDataSet");
DataTable t = new DataTable("Items"); // Add table to the DataSet
ds.Tables.Add(t); // Add columns
DataColumn c1 = new DataColumn("id", Type.GetType("System.Int32"),"");
DataColumn c2 = new DataColumn("Item", Type.GetType("System.Int32"),"");
t.Columns.Add(c1);
t.Columns.Add(c2); // DataColumn array to set primary key.
DataColumn[] keyCol= new DataColumn[1]; // Set primary key column.
keyCol[0]= c1;
t.PrimaryKey=keyCol; // Add a RowChanged event handler for the table.
t.RowChanged += new DataRowChangeEventHandler(Row_Changed); // Add ten rows.
for(int i = 0; i <10;i++){
DataRow r=t.NewRow();
r["id"] = i;
r["Item"]= i;
t.Rows.Add(r);
}
// Accept changes.
ds.AcceptChanges(); PrintValues(ds, "Original values"); // Create a second DataTable identical to the first.
DataTable t2 = t.Clone(); // Add three rows. Note that the id column can't be the
// same as existing rows in the DataSet table.
DataRow newRow;
newRow = t2.NewRow();
newRow["id"] = 14;
newRow["item"] = 774; //Note the alternative method for adding rows.
t2.Rows.Add(new Object[] { 12, 555 });
t2.Rows.Add(new Object[] { 13, 665 }); // Merge the table into the DataSet
Console.WriteLine("Merging");
ds.Merge(t2);
PrintValues(ds, "Merged With table.");}private void Row_Changed(object sender, DataRowChangeEventArgs e){
Console.WriteLine("Row Changed " + e.Action.ToString() + "\t" + e.Row.ItemArray[0]);
}private void PrintValues(DataSet ds, string label){
Console.WriteLine("\n" + label);
foreach(DataTable t in ds.Tables){
Console.WriteLine("TableName: " + t.TableName);
foreach(DataRow r in t.Rows){
foreach(DataColumn c in t.Columns){
Console.Write("\t " + r[c] );
}
Console.WriteLine();
}
}
}
2005-07-09 16:32:00
DataSet的操作在MSDN中有,很详细.