获取或设置一个SQL 语句或存储过程,用于将记录插入到数据集。 语法 [Visual Basic] Public Property InsertCommand As GBaseCommand
GBase 8a 程序员手册ADO.NET 篇 南大通用数据技术股份有限公司
- 193 -
Get
Set [C#] public GBaseCommand InsertCommand {get; set;} 注释 在Update 时,如果这个属性没有设置且主键信息没有在DataSet 中,这时 用户设置了SelectCommand 属性并使用GBaseCommandBuilder,那么 InsertCommand 可以自动生成。而后任何用户没有设置的命令会由 GBaseCommandBuilder 生成,这个生成逻辑需要在DataSet 中有主键信息。 示例 下面的例子中演示如何创建GBaseDataAdapter 对象并设置SelectCommand 和InsertCommand 属性。 [Visual Basic] Public Shared Function CreateCustomerAdapter(conn As GBaseConnection) _ As GBaseDataAdapter Dim da As GBaseDataAdapter = New GBaseDataAdapter() Dim cmd As GBaseCommand Dim parm As GBaseParameter ' Create the SelectCommand. cmd = New GBaseCommand("SELECT * FROM gstable WHERE id=?"_ &"id AND name=?name", conn) cmd.Parameters.Add("?id", GBaseDbType.VarChar, 15) cmd.Parameters.Add("?name", GBaseDbType.VarChar, 15) da.SelectCommand = cmd ' Create the InsertCommand. cmd = New GBaseCommand("INSERT INTO gstable (id,name) "_ &"VALUES(?id, ?name)", conn) cmd.Parameters.Add( "?id", GBaseDbType.VarChar, 15, "id" ) cmd.Parameters.Add( "?name", GBaseDbType.VarChar, 15, "name" ) da.InsertCommand = cmd
GBase 8a 程序员手册ADO.NET 篇
- 194 -
南大通用数据技术股份有限公司 Return da End Function
[C#] Public Static GBaseDataAdapter CreateCustomerAdapter(GBaseConnection conn) { BaseDataAdapter da = new GBaseDataAdapter(); GBaseCommand cmd; GBaseParameter parm; // Create the SelectCommand. cmd = new GBaseCommand("SELECT * FROM gstable WHERE id=?id AND name=?name", conn); cmd.Parameters.Add("?id", GBaseDbType.VarChar, 15); cmd.Parameters.Add("?name", GBaseDbType.VarChar, 15); da.SelectCommand = cmd; // Create the InsertCommand. cmd = new GBaseCommand("INSERT INTO gstable (id,name) VALUES (?id,?name)", conn); cmd.Parameters.Add("?id", GBaseDbType.VarChar, 15, "id" ); cmd.Parameters.Add("?name", GBaseDbType.VarChar, 15, "name" ); da.InsertCommand = cmd; return da; }