demo c#string quStr = "select a1 from a where 0=1"; OracleDataAdapter da = new OracleDataAdapter(quStr,ConnectionString); DataTable dt = new DataTable(); da.FillSchema(dt,SchemaType.Source); OracleCommandBuilder cb = new OracleCommandBuilder(da); DataRow row = dt.NewRow(); row["a1"] = Uplist.Trim(); dt.Rows.Add(row); da.Update(dt);
程序中实现的话
对指定行记录进行
Update
OracleDataAdapter da = new OracleDataAdapter(quStr,ConnectionString);
DataTable dt = new DataTable();
da.FillSchema(dt,SchemaType.Source);
OracleCommandBuilder cb = new OracleCommandBuilder(da);
DataRow row = dt.NewRow();
row["a1"] = Uplist.Trim();
dt.Rows.Add(row);
da.Update(dt);