I have a Win Form where I select a Employee and CheckListBox where I selecte multiple stores. In my store procedure I am passing EmployeeID and StoreString with comma delimited. Such as EmployeID = 1095 and StoreString = 105,905,255,991,303. I need to save these values in my EmployeeStoreLink Table as of following...
1095 = 105
1095 = 905
1095 = 255
1095 = 991
1095 = 303
I also need to rollback prior records insert if store insert @ 303 fails. I have done few hours of research and only stuffs that I found was how to retrive information but not how to insert them into the table. If anyone would give me some hint I would greatly appreciate.
Loading
Arun KumarPosted Nov 9, 2007, 3:32 PM
for example strXml = "
This string U can send to db with @UserID .
In MSSql use the xml parameter to handle the item variable value.
Use a cursor and retrieve the data in a while loop..
Ur few line code will execute ur purpose without considering the no. of items or limit of the parameter U pass.
- AMG