刚入门.net 请帮我下

[x108133962]

举例,有一表 tb_a 中有字段 ID,title

请帮我写添加,删除,修改,函数,给予实例

我目前只写完了连接数据库,请大家帮我
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection objSqlConnection = new SqlConnection("server=.;uid =sa;pwd=123456;database=dadn");
objSqlConnection.Open();

}

[x108133962]

还有查询语句,谢谢

[devilli]

首先把数据拿下来
string selectSql = "select id, title from tb_a";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(selectSql, objSqlConnection);
DataSet ds = new DataSet();
ds = adapter.Fill(ds, "tb_a");

添加
DataRow newDr = ds.Tables["tb_a"].NewRow();
newDr["id"] = 100;
newDr["title"] = "title";
ds.Tables["tb_a"].Rows.Add(newDr);

System.Data.SqlClient.SqlCommandBuilder builder = new System.Data.SqlClient.SqlCommandBuilder(adapter);
adapter.Update(ds, "tb_a");

ps:需要确定id是不是自动的

[devilli]

删除
DataRow deleteDr = ds.Tables["tb_a"].Rows[index];//index是要删除的行号
ds.Tables["tb_a"].Rows.Remove(deleteDr);
ds.AcceptChanges();
adapter.Update(ds, "tb_a");

修改
DataRow modifyDr = ds.Tables["tb_a"].Rows[index];//index是要修改的行号
modifyDr["id"] = 101;
modifyDr["title"] = "newtitle";
ds.AcceptChanges();
adapter.Update(ds, "tb_a");

[tian_fang]

如楼上所说