Code:
SqlParameter shipperIDParameter = new SqlParameter("@ShipperID", SqlDbType.Int);
shipperIDParameter.Direction = ParameterDirection.Output; insertCommand.Parameters.Add(shipperIDParameter);
siddu57
Last Activity: Mar 25 '08, 11:01 PM
Joined: Feb 29 '08
Location:
-
Thank you. That resource is very helpful but I'm not sure how to do this last bit in VB instead of C#:
-
Retrieving Identity field
I have 2 tables - tblOrders and tblOrderDetails . Every time an order is placed, 2 INSERT statements are executed. The first one enters the general order and customer information in the tblOrders table:
The primary key in this table is OrderID which is an Identity column. This is the foreign key in the tblOrderDetails...Code:INSERT INTO tblOrders (custname, custdetails, orderdate) VALUES (@custname, @custdetails, @orderdate)
-
@@identity
I got two tables
one table has the fields ie table1
orderid ofd orderdate customername
where order id is autonumber
the other table2
orderid ofd product id productname
the problem here is that
if customer purchases 3 product at a time all the 3 products get the same ofd number ........and any 2 customers can have the same ofd... -
@@ identity
I got two tables
one table has the fields ie table1
orderid ofd orderdate customername
where order id is autonumber
the other table2
orderid ofd product id productname
the problem here is that
if customer purchases 3 product at a time all the 3 products get the same ofd number ........and any 2 customers can have the same ofd... -
@@identity
I got two tables
one table has the fields ie table1
orderid ofd orderdate customername
where order id is autonumber
the other table2
orderid ofd product id productname
the problem here is that
if customer purchases 3 product at a time all the 3 products get the same ofd number ........and any 2 customers can have the same ofd...
No activity results to display
Leave a comment: