Need procedure for insert two table at a time and truncate table
Like table1
Button1 I need to insert these two tables in front end asp.net using c# (web application)
Date 18.8.13
Productname cement
Price 300
Extra 10 (310*14.5/100)=44.95
Vat 14.5/100
Total 354.95
Table2
Date
Productname: closeup
Price 50
Vat 14.5/100
Total 57.25
Button 2 click event I need to truncate table1
Loading
Iftikar HussainPosted Aug 19, 2013, 1:37 AM
If you don't know how to create procedure, then go thru the below link
http://www.codeproject.com/Articles/38682/Overview-of-SQL-Server-Stored-Procedure
Regards,
Iftikar
selvi subramanianPosted Aug 19, 2013, 1:34 AM
hussain i need to multiply the dropdown value and textbox value .
Iftikar HussainPosted Aug 19, 2013, 1:30 AM
selvi subramanianPosted Aug 19, 2013, 1:27 AM
Jignesh TrivediPosted Aug 18, 2013, 11:05 PM
Can you please provide more information? so that we can help you.
we are not getting you problem.
Iftikar HussainPosted Aug 18, 2013, 4:37 AM
Create procedure for deleting record from table1 . You want to truncate or delete data from TABLE1
Regards,
Iftikar