How can you execute stored procedure from windows application?



How can you execute stored procedure from windows application?..

Answer / 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

More ASP.NET Interview Questions

What is MSIL?

4 Answers  


6. Tell us about a time when you failed to meet a deadline. What were the repercussions?

0 Answers   AlKhaleej, Swatz Oils,


What is cross page posting in asp net?

0 Answers  


What is the full meaning of asp.net?

0 Answers  


How many types of session in asp.net2.0

28 Answers   ABC, DOT, First Europa, HCL, iRely, TCS,






What is voluum?

0 Answers  


Explain the updatepanel?

0 Answers  


How to set the pane area to transparent of a scrollPane component.?

0 Answers   MCN Solutions,


List of words of preprocessor in .net?

0 Answers  


How many types of cookies are available in asp?

0 Answers  


What is Master Page in Asp.net?

9 Answers  


What is advantage of viewstate and what are benefits ?

1 Answers  


Categories