Đang chuẩn bị liên kết để tải về tài liệu:
Using Stored Procedures to Add, Modify, and Remove Rows from the Database phần 2

Setting the InsertCommand Property of a DataAdapter The following example creates a SqlCommand object named myInsertCommand that contains a call to the AddProduct4() stored procedure | Setting the InsertCommand Property of a DataAdapter The following example creates a SqlCommand object named mylnsertCommand that contains a call to the AddProduct4 stored procedure SqlCommand mylnsertCommand mySqlConnection.CreateCommand mylnsertCommand.CommandText EXECUTE @MyProductID AddProduct4 @MyProductName @MyUnitPrice myInsertCommand.Parameters.Add @MyProductID SqlDbType.Int 0 ProductID myInsertCommand.Parameters @MyProductID .Direction ParameterDirection.Output myInsertCommand.Parameters.Add @MyProductName SqlDbType.NVarChar 40 ProductName myInsertCommand.Parameters.Add @MyUnitPrice SqlDbType.Money 0 UnitPrice As you can see from the previous code the direction of the @MyProductID parameter is set to ParameterDirection.Output which indicates that this parameter is an output parameter. Also the maximum length of the @MyProductID and @MyUnitPrice parameters is set to 0 in the third parameter to the Add method. Setting them to 0 is fine because the maximum length doesn t apply to fixed length types such as numbers only to types such as strings. Next the following example sets the InsertCommand property of mySqlDataAdapter to myInsertCommand mySqlDataAdapter.InsertCommand myInsertCommand Setting the UpdateCommand Property of a DataAdapter The following example creates a SqlCommand object named myUpdateCommand that contains a call to the UpdateProduct stored procedure and sets the UpdateCommand property of mySqlDataAdapter to myUpdateCommand SqlCommand myUpdateCommand mySqlConnection.CreateCommand myUpdateCommand.CommandText EXECUTE UpdateProduct @OldProductID @NewProductName @NewUnitPrice @OldProductName @OldUnitPrice myUpdateCommand.Parameters.Add @OldProductID SqlDbType.Int 0 ProductID myUpdateCommand.Parameters.Add @NewProductName SqlDbType.NVarChar 40 ProductName myUpdateCommand.Parameters.Add @NewUnitPrice SqlDbType.Money 0 UnitPrice myUpdateCommand.Parameters.Add @OldProductName SqlDbType.NVarChar 40 ProductName myUpdateCommand.Parameters.Add .