(vs2008+oracle)gridview删除数据的方法

一，使用command方法删除数据：

 

            OracleConnection conn = new OracleConnection(constr);
            OracleCommand comm = new OracleCommand();
            comm.CommandText = "delete from products where productid=" + GridView1.Rows[e.RowIndex].Cells[0].Text;
            comm.Connection = conn;
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();

二，参数

 

            OracleConnection conn = new OracleConnection(constr);
            OracleCommand comm = new OracleCommand();
            comm.CommandText = "delete from products where productid=:productid";
            comm.Parameters.AddWithValue(":productid", GridView1.Rows[e.RowIndex].Cells[0].Text);
            comm.Connection = conn;
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();

 

 

三，使用oraclecommandbuilder方法删除数据

 DataSet ds = new DataSet();
            OracleDataAdapter da = new OracleDataAdapter(strSQL, constr);
            da.Fill(ds,"mytable");
            DataTable dt = ds.Tables["mytable"];
            dt.PrimaryKey = new DataColumn[] { dt.Columns["productid"] };
            DataRow dr = dt.Rows.Find(GridView1.Rows[e.RowIndex].Cells[0].Text);
            dr.Delete();
            OracleCommandBuilder cb = new OracleCommandBuilder(da);
            da.Update(ds, "mytable");