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 the difference between a default skin and a named skin?
What tags do you need to add within the asp:datagrid tags to bind columns manually?
What is a url string?
What is Difference between Callbacks and Postback in ASP.NET?
What is use of <% %> in asp.net?
Why viewstate is used in asp.net?
.net allows which inheritence
6 Answers AG Technologies, Samcomm,
What r the page life cycle in asp.net page?
Explain the difference between dataset and datareader.
What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?
What is difference b/w Generic List and Arraylist, Generic List Vs HashTable, Generic List Vs No Generic? Pls Explain with example.
What is mvc in asp.net interview question? : Asp.Net MVC
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)