asp.net对数据库增删改操作

有三种
protected void Button1_Click(object sender, EventArgs e)
{
string id = TextBox1.Text.Trim();
string name = TextBox2.Text.Trim();
string sex = DropDownList1.Text;
string department = DropDownList2.Text;
string constr = ConfigurationManager.ConnectionStrings["xby"].ToString();
MySqlConnection conn = new MySqlConnection(constr);
conn.Open();
string selstr = "select * from student";
MySqlDataAdapter da = new MySqlDataAdapter(selstr, conn);
MySqlCommandBuilder builder = new MySqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow mr = dt.NewRow();
mr[0] = id;
mr[1] = name;
mr[2] = sex;
mr[3] = department;
dt.Rows.Add(mr);
da.Update(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
conn.Close();
}

    protected void Button2_Click(object sender, EventArgs e)
    {
        string id = TextBox3.Text.Trim();
        string tname = TextBox4.Text.Trim();
        string tclass = TextBox5.Text.Trim();
        string constr1 = ConfigurationManager.ConnectionStrings["xby"].ToString();
        MySqlConnection conn1 = new MySqlConnection(constr1);
        conn1.Open();
        string selstr1 = "select * from teacher";
        MySqlDataAdapter da1 = new MySqlDataAdapter();
        da1.SelectCommand = new MySqlCommand(selstr1, conn1);
        MySqlCommandBuilder builder = new MySqlCommandBuilder(da1);
        DataSet ds = new DataSet();
        da1.Fill(ds);
        DataRow NewRow = ds.Tables[0].NewRow();
        NewRow[0] = id;
        NewRow[1] = tname;
        NewRow[2] = tclass;
        ds.Tables[0].Rows.Add(NewRow);
        da1.Update(ds);
        Response.Write("<script language=javascript>alert(‘新纪录添加成功‘)");
        GridView2.DataSource = ds.Tables[0];
        GridView2.DataBind();
        conn1.Close();
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        string id = TextBox6.Text.Trim();
        string cname = TextBox7.Text.Trim();
        string tname = TextBox8.Text.Trim();
        string constr2 = ConfigurationManager.ConnectionStrings["xby"].ToString();
        MySqlConnection conn2 = new MySqlConnection(constr2);
        conn2.Open();
        string selstr2 = "select * from course";
        MySqlCommand command = new MySqlCommand(selstr2, conn2);
        MySqlDataReader dr = cmd.ExecuteReader();
        GridView3.DataSource = dr;
        GridView3.DataBind();
        string sql3 = "Insert into course(id,cname,tname) Values(‘05‘,‘线性代数‘,‘黎明‘)";
        MySqlCommand cmd = new MySqlCommand(sql3, conn2);
        int Num = cmd.ExecuteNonQuery();
        Response.Write("受影响的记录数为:" + Num.ToString());
        MySqlDataReader dr = cmd.ExecuteReader();
        GridView3.DataSource = dr;
        GridView3.DataBind();
        conn2.Close();
    }

asp.net对数据库增删改操作

上一篇:CAD三维实体入门(三):三维实体图的常见方法


下一篇:Oracle之coalesce函数