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 |
What is MSIL?
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?
What is the full meaning of asp.net?
How many types of session in asp.net2.0
28 Answers ABC, DOT, First Europa, HCL, iRely, TCS,
What is voluum?
Explain the updatepanel?
How to set the pane area to transparent of a scrollPane component.?
List of words of preprocessor in .net?
How many types of cookies are available in asp?
What is Master Page in Asp.net?
What is advantage of viewstate and what are benefits ?