01.
.
02.
.
03.
.
04.
05.
adapter.UpdateCommand =
new
MySqlCommand(
06.
"UPDATE
items SET ItemName=@ItemName, Price=@Price,
AvailableQuantity=@AvailableQuantity, Updated_Dt=NOW() WHERE
ItemNumber=@ItemNumber;"
,connection);
07.
adapter.UpdateCommand.Parameters.Add(
"@ItemNumber"
, MySqlDbType.Int16, 4,
"ItemNumber"
);
08.
adapter.UpdateCommand.Parameters.Add(
"@ItemName"
, MySqlDbType.VarChar, 100,
"ItemName"
);
09.
adapter.UpdateCommand.Parameters.Add(
"@Price"
, MySqlDbType.Decimal, 10,
"Price"
);
10.
adapter.UpdateCommand.Parameters.Add(
"@AvailableQuantity"
, MySqlDbType.Int16, 11,
"AvailableQuantity"
);
11.
adapter.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
12.
13.
14.
adapter.InsertCommand =
new
MySqlCommand(
15.
"INSERT INTO items VALUES (@ItemNumber,@ItemName,@Price,@AvailableQuantity,NOW());"
,connection);
16.
adapter.InsertCommand.Parameters.Add(
"@ItemNumber"
, MySqlDbType.Int16, 4,
"ItemNumber"
);
17.
adapter.InsertCommand.Parameters.Add(
"@ItemName"
, MySqlDbType.VarChar, 100,
"ItemName"
);
18.
adapter.InsertCommand.Parameters.Add(
"@Price"
, MySqlDbType.Decimal, 10,
"Price"
);
19.
adapter.InsertCommand.Parameters.Add(
"@AvailableQuantity"
, MySqlDbType.Int16, 11,
"AvailableQuantity"
);
20.
adapter.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
21.
22.
23.
adapter.DeleteCommand =
new
MySqlCommand(
24.
"DELETE FROM items "
+
"WHERE ItemNumber=@ItemNumber;"
, connection);
25.
adapter.DeleteCommand.Parameters.Add(
"@ItemNumber"
, MySqlDbType.Int16, 4,
"ItemNumber"
);
26.
adapter.DeleteCommand.UpdatedRowSource = UpdateRowSource.None;
27.
.
28.
.
29.
.
No comments:
Post a Comment