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 can we apply themes to an asp.net application?
We Only Know The Total Number Of Feet In The Farmyard. Write A Program that will compute the total number of rabbits and chickens in the farmyard. Assume number of feet in the farmyard are 40. how many rabbits and chickens are?
Give 2 examples for scenarios when routing is not applied?
Explain the benefits of viewstate?
How to create discussion forum in asp.net mvc? : Asp.Net MVC
Explain the difference between asp.net mvc and asp.net webforms
What is http session state?
What is state management techniques in asp.net?
How is my content secured from unauthorized access?
How to implement Authentication and Authorization?
What is the advantage of mvc over asp.net? : Asp.Net MVC
What is the difference between typeof() vs gettype()?
Please brief not about xsd,xslt & xml?
Define static function?
What is recordset asp?