Click here to Skip to main content
14,981,116 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
I am saving data using sqltransaction ( commit and roll back )

issue is

when I try to delete record before saving ...its not deleting but saving logic is working

when I make separate function to delete records its working ...(separate connection string)

why its not working in same function where saving procedure is working using sqltransaction

I need to delete details and master before inserting/saving records

need help
[no name] 29-Oct-13 6:16am
please put some code to understand :?
ZurdoDev 29-Oct-13 7:33am
Who knows? We can't see your code. Why isn't it working?

1 solution

I have solved myself

data type was wrong

when I am passing parameter using store procedure

data type was not matched (between store procedure and front end )

in delete store procedure

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900