62,046
社区成员
发帖
与我相关
我的任务
分享
using (OracleDataAdapter da = new OracleDataAdapter())
{
try
{
string strSQL="Select * from t1";
OpenConn();//打开连接
OracleCommand cmd;
OracleParameter parm;
DataTable dt = new DataTable();
cmd = new OracleCommand(strSQL, conn);
da.SelectCommand = cmd;
da.Fill(dt);
string delsql = "DELETE FROM t1 WHERE ID=:pID";
cmd = new OracleCommand(delsql, conn);
parm = cmd.Parameters.Add(":pID", OracleType.VarChar, 50, "ID");
parm.SourceVersion = DataRowVersion.Original;
da.DeleteCommand = cmd;
// int a = da.Update(dt);
}
catch (Exception ex)
{
//省略
}
}
OpenConn();
OracleCommand cmd;
OracleParameter parm;
DataTable dt = new DataTable();
DataTable dt0 = new DataTable();
cmd = new OracleCommand(strSQL, conn);
da.SelectCommand = cmd;
da.Fill(dt);
dt0 = dt.Copy(); //复制此表便于其他操作,否则所有行都为空。
foreach (DataRow dr in dt.Rows)
{
dr.Delete();
}
string delsql = "DELETE FROM CMPP_SUBMIT WHERE ID=:pID";
cmd = new OracleCommand(delsql, conn);
parm = cmd.Parameters.Add(":pID", OracleType.VarChar, 50, "ID");
parm.SourceVersion = DataRowVersion.Original;
da.DeleteCommand = cmd;
da.Update(dt);
adapter.Fill(dt);
dt.Rows[1].Delete();//删除DataTable中的某一行,根据需要自行删除
adapter.DeleteCommand = com;
adapter.Update(dt);
public static OracleDataAdapter CreateCustomerAdapter(OracleConnection conn)
{
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cmd;
OracleParameter parm;
// Create the SelectCommand.
cmd = new OracleCommand("SELECT * FROM Dept " +
"WHERE DName = :pDName AND Loc = :pLoc", conn);
cmd.Parameters.Add("pDName", OracleType.NVarChar, 14);
cmd.Parameters.Add("pLoc", OracleType.NVarChar, 13);
da.SelectCommand = cmd;
// Create the DeleteCommand.
cmd = new OracleCommand("DELETE FROM Dept WHERE DeptNo = :pDeptNo", conn);
parm = cmd.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");
parm.SourceVersion = DataRowVersion.Original;
da.DeleteCommand = cmd;
return da;
}