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 r the asp.net list controls and difference between them?
Explain the namespace classes used in asp.net mvc? : asp.net mvc
What is the good practice to implement validations in aspx page?
What is Model-View-View Model?
What is the difference between mvc and asp.net? : Asp.Net MVC
When does a session actually start?
What is the function of the ViewState property?
What is active web pages?
Explain the asp.net session state modes.
What is a page life cycle? What are the events in a page life cycle?
Can you change a Master Page dynamically at runtime?
Name the namespace which is used by ado.net?
What is server side routing?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
Can I recieve both html markup for page and code in the asp.net web page's source code portion in the web browser?