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
How about the security in Activex DLL and Activex EXE ?
If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?
What is variable and constant in .net programming language?
What is cache in asp net?
What are the options in ASP.NET to maintain state?
What is the difference between WindowsDefaultLocation and WindowsDefaultBounds?
How long does an http session last?
what is loosely coupled solution? How it can be used?
Explain login controls.
What are the asp.net list controls and difference between them?
What is a viewbag?
Why do we use sessions?
What is difference between View State and Hidden Field in ASP.NET?
What kind of data we can store in viewstate?
What is the concept of postback in asp.net?