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
What is webresource axd?
What are cookies in your browser?
What are the steps involved to fill a dataset?
what is the difference between response.write() and response.output.write()?
What are the session variables?
Why do we need asp.net?
Can asp.net work on an nt server?
When cookie will expire?
What is syntax code to send email from an asp.net application?
How can you apply a theme to your asp.net application?
How to deploy/publish webservices?How many ways?Plz explain me
What is the purpose of session management?
What is the difference between client-side and server-side validations in ASP.NET?
what cut off mark for po's,what questions they asked for interview?
Can you change a Master Page dynamically at runtime?