java datarow 使用_Datatable和DataRow的使用

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] + "
";

}

}