Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can you execute stored procedure from windows application?

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


Please Help Members By Posting Answers For Below Questions

What r the asp.net list controls and difference between them?

981


Explain the namespace classes used in asp.net mvc? : asp.net mvc

954


What is the good practice to implement validations in aspx page?

1043


What is Model-View-View Model?

965


What is the difference between mvc and asp.net? : Asp.Net MVC

961


When does a session actually start?

990


What is the function of the ViewState property?

987


What is active web pages?

919


Explain the asp.net session state modes.

1034


What is a page life cycle? What are the events in a page life cycle?

856


Can you change a Master Page dynamically at runtime?

931


Name the namespace which is used by ado.net?

920


What is server side routing?

886


if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....

2080


Can I recieve both html markup for page and code in the asp.net web page's source code portion in the web browser?

889