介绍Datatable和DataRow的使用

    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] + "&nbsp;&nbsp;&nbsp;&nbsp;" + data.Tables["company"].Rows[i][1] + "<br>";
        }
      
    }