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

How about the security in Activex DLL and Activex EXE ?

2230


If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

943


What is variable and constant in .net programming language?

764


What is cache in asp net?

960


What are the options in ASP.NET to maintain state?

1073


What is the difference between WindowsDefaultLocation and WindowsDefaultBounds?

1115


How long does an http session last?

888


what is loosely coupled solution? How it can be used?

959


Explain login controls.

1059


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

972


What is a viewbag?

913


Why do we use sessions?

948


What is difference between View State and Hidden Field in ASP.NET?

1094


What kind of data we can store in viewstate?

993


What is the concept of postback in asp.net?

1000