110,534
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Server=.\SQLEXPRESS;Database=learn;Trusted_Connection=True");
SqlDataAdapter da = new SqlDataAdapter("select * from temp", con);
DataSet ds = new DataSet();
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(ds);
DataColumn[] key = new DataColumn[] { ds.Tables[0].Columns[0] };
ds.Tables[0].PrimaryKey = key;
ds.Tables[0].Rows[0].Delete();
da.Update(ds);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Server=.\SQLEXPRESS;Database=learn;Trusted_Connection=True");
SqlDataAdapter da = new SqlDataAdapter("select * from temp", con);
DataSet ds = new DataSet();
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(ds);
ds.Tables[0].Rows[0].Delete();
da.Update(ds);
}