我在一个按钮触发的事件里:
private void button1_Click(object sender, EventArgs e)
{ string s = jm(textBox2.Text, out publickey); //RSA加密,生成密文和密钥
SqlDataAdapter sda = new SqlDataAdapter("select * from denglu",lianjie.s);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataTable dt = new DataTable();
sda.Fill(dt);
dt.PrimaryKey = new DataColumn[] { dt.Columns["usename"] };
DataRow dr;
dr = dt.NewRow();
dr["usename"] = textBox1.Text;
dr["password"] = s ;
dr["miyao"] = publickey;
dt.Rows.Add(dr);
sda.Update(dt);
}
为什么运行后数据库里没有增加数据呢?
private void button1_Click(object sender, EventArgs e)
{ string s = jm(textBox2.Text, out publickey); //RSA加密,生成密文和密钥
SqlDataAdapter sda = new SqlDataAdapter("select * from denglu",lianjie.s);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataTable dt = new DataTable();
sda.Fill(dt);
dt.PrimaryKey = new DataColumn[] { dt.Columns["usename"] };
DataRow dr;
dr = dt.NewRow();
dr["usename"] = textBox1.Text;
dr["password"] = s ;
dr["miyao"] = publickey;
dt.Rows.Add(dr);
sda.Update(dt);
}
为什么运行后数据库里没有增加数据呢?
da.Update(ds);
或
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = cmd;
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Update(ds);
SqlDataAdapter sda = new SqlDataAdapter("select * from denglu",lianjie.s);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
{ string s = jm(textBox2.Text, out publickey); //RSA加密,生成密文和密钥
SqlDataAdapter sda = new SqlDataAdapter("select * from denglu",lianjie.s); DataTable dt = new DataTable();
sda.Fill(dt);
dt.PrimaryKey = new DataColumn[] { dt.Columns["usename"] };
DataRow dr;
dr = dt.NewRow();
dr["usename"] = textBox1.Text;
dr["password"] = s ;
dr["miyao"] = publickey;
dt.Rows.Add(dr);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
sda.Update(dt);
}
SqlDataAdapter da = new SqlDataAdapter("Select * from Tb", conn);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close(); ds.Tables[0].Rows[1]["NAME"] = "";
conn.Open();
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
da.Update(ds.Tables[0]);
conn.Close();
没问题