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

0
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
Posted
Comments
[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