How can you execute stored procedure from windows application?
Answer Posted / jigneshsanghvi
Stored proc. can be executed using command object by
ExecuteNonQuery method.
Sample Code :
Dim cnn as new sqlconnection
cnn.connectionstring=constr
cnn.open()
Dim cmd as new sqlcommand
cmd.connection=cnn
cmd.commandtext = "ProcName" & parameter list separated by comma
cmd.ExecuteNonQuery()
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the steps needed to be performed in order to create an animation in xaml?
What is the web.config file in asp?
Explain diff. Betn dataset and recordset?
Why would anyone need to implement their own hashtable or linked list?
How to integrate angular 8 with asp.net mvc 5? : Asp.Net MVC
Do session use cookies in asp net?
What does postback mean?
What is a form tag?
Define static member?
Can you explain one critical mapping? Performance issue which one is better?
What is a server farm in iis?
What are the Types of chaching. How to implement caching
How do you use viewstate?
Can anyone please tell me that the question posted on this website are Sufficient for the interview with 2+ year experience in .net
Explain the page lifecycle of an asp.net mvc? : asp.net mvc