求用SqlCommandBuilder 更新数据库办法

来源：百度知道 编辑：UC知道 时间：2024/06/01 12:18:58
在aspx 里写的如下代码
目的是更新一行里面的某个属性。
联系也可以用qq 178451883
protected void ok_Click(object sender, EventArgs e)
{
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["jobmanageConnectionString"].ConnectionString;
SqlConnection Conn = new SqlConnection(strConn);
Conn.Open();

DataSet ds = new DataSet();
string strSql = "select * from jiuye where xuehao = '" + name + "'";
SqlDataAdapter da = new SqlDataAdapter(strSql,Conn);
da.Fill(ds, "jiuye");
SqlCommandBuilder cb = new SqlCommandBuilder (da);
DataTable dt = ds.Tables["jiuye"];
DataRow dr = dt.Rows[0];
dr["jiuyebiaozhiid"] = jybz.Text;
da.Update(ds, "jiuye");

Conn.Close();

}

string connectionString = string.Empty;
string id = string.Empty;
string newValue = string.Empty;
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
try
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("SELECT * FROM jiuye WHERE xuehao = @ID", connection);
adapter.SelectCommand.Parameters.Add("@ID", SqlDbType.Int, 4, ID);
adapter.SelectCommand.Parameters[0].Value = id;
adapter.UpdateCommand = new SqlCommand("UPDATE jiuye SET jiuyebiaozhiid = @Value WHERE xuehao = @ID", connection);
adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Value", SqlDbType.VarChar, 50, "jiuyebiaozhiid"));
adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, "xuehao"));
DataSet ds = new DataSet();
adapter.Fill(d