C# dataset
来源:互联网 发布:公务员考试 知乎 编辑:程序博客网 时间:2024/06/06 16:25
表一定要有主键!!!!
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=pp");
SqlDataAdapter da = new SqlDataAdapter("select * from tableww", con);
ds = new DataSet();
da.Fill(ds);
this.gridControl1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=pp");
SqlDataAdapter da = new SqlDataAdapter("select * from tableww", con);
cmb = new SqlCommandBuilder(da);
da.UpdateCommand = cmb.GetUpdateCommand();
da.InsertCommand = cmb.GetInsertCommand();
da.DeleteCommand = cmb.GetDeleteCommand();
da.Update(ds.GetChanges());
ds.AcceptChanges();
}
datatable的select方法
private void repositoryItemRadioGroup1_EditValueChanging(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e)
{
int[] i = gridView1.GetSelectedRows();
DataRow[] dr = ds.Tables[0].Select("id =" + gridView1.GetDataRow(i[0])[0].ToString());
foreach (DataRow d in dr)
{
d[2] = e.NewValue.ToString();
}
}
多表查询用容器嵌套
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=;database=qq");
new SqlDataAdapter("select * from Users", conn).Fill(ds, "Users");
new SqlDataAdapter("select * from Roles", conn).Fill(ds, "Roles");
new SqlDataAdapter("select * from UserRoleJoin", conn).Fill(ds, "UserRoleJoin");
//DataRelation
DataRelation del1 = new DataRelation("UserRoleJoin", ds.Tables["Users"].Columns["UserId"], ds.Tables["UserRoleJoin"].Columns["UserId"], false);
DataRelation del2 = new DataRelation("Roles", ds.Tables["UserRoleJoin"].Columns["RoleId"], ds.Tables["Roles"].Columns["RoleId"], false);
ds.Relations.Add(del1);
ds.Relations.Add(del2);
this.DataList1.DataSource = ds.Tables["Users"].DefaultView;
this.DataList1.DataBind();
//((System.Data.DataRowView)Container.DataItem).CreateChildView("UserRoleJoin");
- C# dataset
- C# DataSet
- C# DataSet&DataTable
- c# 中DataSet示例
- c#中dataset存取
- C#之DataSet类
- C# 强类型DataSet
- c# dataset 例子
- C# DataSet的使用
- C#之DataSet类
- C# 操作Dataset介绍
- C# DataSet类
- c# - DataSet To String
- C# DataSet.RejectChanges 方法
- C# DataSet.Clear 方法
- C# DataSet.AcceptChanges 方法
- C# List转DataSet
- C# DataSet 的使用
- ubuntu右键在当前目录执行终端terminal程序
- WIN32汇编程序的编译方法,环境配置,make的简单应用
- 在Oracle中查看所有的表
- 如何在删除并重新安装 IIS 之后修复 IIS 映射
- asp.net web services
- C# dataset
- 呵呵,又是好一阵子没写了
- 测试FetchType
- Flash cs3 Trial Day4 新功能:version control
- VC 预编译找不到头文件
- ASP.NET封装的SQL数据库访问类
- Web Services的简单介绍
- 软件开发委托(单位)协议
- asp.net常用函数