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 a SESSION and APPLICATION object?
difference between Trace and Debug ?
2 Answers Accenture, HCL, Patni,
Types of state management techniques ?
What are the advantages of asp.net?
how many character send in one sms forget 160limit and think about gateway allowed
Why does my asp.net file have multiple tag with runat=server?
What is the use of dispose method?
how can we create wcf in asp.net and how can we cll that in to asp.net application?plsss tel me each step clearly
What is the difference between Trace and Debug?
How can you use a custom controls in ASP.NET application?
0 Answers Sans Pareil IT Services,
Which is better asp.net or php?
How can we identify that the Page is Post Back?
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)