asp.net手动指定SQL语句

 手动指定SQL语句

string connStr = "…… ";

string selectStr = "SELECT * FROM TableName";

OracleConnection conn = new OracleConnection(connStr);

OracleCommand cmd = new OracleCommand(selectStr, conn);

OracleDataAdapter ada = new OracleDataAdapter(cmd);

DataSet ds = new DataSet();

ada.Fill(ds, "TableName");

 

// 修改DataSet中的数据

…

// 定义Select语句

OracleCommand cmdSelect = new OracleCommand(selectStr, conn);

// 定义Insert语句

OracleCommand cmdInsert = new OracleCommand();

cmdInsert.Connection = conn;

cmdInsert.CommandText = "Insert Into Table_name (F1, …) Values

(:field, …)";

cmdInsert.Parameters.Add("field ", OracleType.VarChar, 12, "F1");

……

// 定义Update语句

OracleCommand cmdUpdate = new OracleCommand();

cmdUpdate.Connection = conn;

cmdUpdate.CommandText = "Update Table_name Set F1=:field, … where 

ID=:id";

cmdUpdate.Parameters.Add(new OracleParameter("field",

OracleType.Number, 4, "F1"));

……

cmdUpdate.Parameters.Add(new OracleParameter("id",

OracleType.VarChar, 10, "ID")).SourceVersion =

DataRowVersion.Original;        // 表中ID列为主键

// 定义Delete语句

OracleCommand cmdDelete = new OracleCommand();

cmdDelete.Connection = conn;

cmdDelete.CommandText = "Delete From Table_name where ID = :id";

cmdDelete.Parameters.Add(new OracleParameter("id",

OracleType.VarChar, 10, "ID")).SourceVersion =

DataRowVersion.Original;

 

OracleDataAdapter ada = new OracleDataAdapter(cmdSelect);

ada.InsertCommand = cmdInsert;

ada.UpdateCommand = cmdUpdate;

ada.DeleteCommand = cmdDelete;

 

ada.Update(ds, "TableName");

ds.AcceptChanges();

 

以上是一部分介绍,如需要完整的资料或者如不符合您的要求,请联系技术人员qq:242219979咨询

上一篇：asp.net把对DataSet的修改到数据库
下一篇：vb电脑销售系统