How can you execute stored procedure from windows application?
- 1 Answers
- 3210 Views
- Microsoft, I also Faced
- E-Mail Answers
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 are sql joins?
What do you mean by marshalbyref?
What does clearing cache?
What is the asp.net mvc folder conventions? : asp.net mvc
What is manifest in .net framework?
How many types of state management are there in asp net?
Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?
To bind columns manually which tags do you need to add within the asp:datagrid ?
What are the various session state management options provided by asp.net?
What do you mean by authentication?
What are sql notifications and sql invalidations?
What is state management technique?
Give an example of cookie abuse.
How do you deploy your asp.net application?
How does the service stream content?
