SqlConnection conn = new SqlConnection(); DataSet data = new DataSet(); SqlDataAdapter da; String sqlStr; SqlCommandBuilder cb; protected void Page_Load(object sender, EventArgs e) { try { sqlStr = "select * from company"; conn.ConnectionString = "server=(local);DataBase=contacters;uid=sa;pwd=zhuang"; da = new SqlDataAdapter(sqlStr, conn); cb = new SqlCommandBuilder(da); da.Fill(data, "company"); ViewCompany(data); } catch (Exception ex) { Response.Write(ex.Message.ToString()); } } protected void Button1_Click(object sender, EventArgs e) { DataTable dt = data.Tables[0]; DataRow dr1 = dt.NewRow(); DataRow dr2 = dt.NewRow(); //增加第一行 dr1[0] = TextBox1.Text; dr1[1] = TextBox2.Text; dt.Rows.Add(dr1); //增加第二行 dr2[0] = TextBox3.Text; dr2["name"] = TextBox4.Text; dt.Rows.Add(dr2); da.Update(dt); ViewCompany(data); } protected void Button2_Click(object sender, EventArgs e) { DataTable dt = data.Tables[0]; DataRow dr1, dr2; //找到要修改的记录行 for (int i = 0; i < dt.Rows.Count; i++) { if(dt.Rows[i][0].ToString()==TextBox1.Text) { dr1 = dt.Rows[i]; dr1["name"] = TextBox2.Text; } if (dt.Rows[i][0].ToString() == TextBox2.Text) { dr2 = dt.Rows[i]; dr2["name"] = TextBox4.Text; } } da.Update(dt); ViewCompany(data); } protected void Button3_Click(object sender, EventArgs e) { DataTable dt = data.Tables[0]; //找到要删除的记录行 for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][0].ToString() == TextBox1.Text || dt.Rows[i][0].ToString() == TextBox3.Text) { dt.Rows[i].Delete(); } } da.Update(dt); ViewCompany(data); } protected void ViewCompany(DataSet data) { Label1.Text = ""; //将 DataSet 的数据写入 Label for (int i = 0; i < data.Tables["company"].Rows.Count; i++) { Label1.Text += data.Tables["company"].Rows[i][0] + " " + data.Tables["company"].Rows[i][1] + "<br>"; } }