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...

what are the two key events for the sql connection class?
explain the differnce between the two.

Answer Posted / annie

The two key event of sqlConnection class are:
StateChange event:Occurs only when the state of the connection with the database changes. The evnthandler receives an argument of type StateChangeEventArgs. This argument contains data related to that perticular event.
The properties of this event are: CurrentState and OriginalState.
InfoMessage event: Occurs only when an informational message returned from the database having connection with. The event handler receives an argument of type SqlInfoMessageEventArgs. This argument contains the data related to that particular event.
The properties of this event are: Error,Message and Source.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid in ado.net?

948


Which control of the BindingNavigator returns the current position within the data source?

1109


What is data view and variable view?

855


What is connection string?

954


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

969


What is the use of SqlCommandBuilder?

1145


Explain how to pass multiple tables in datasets simultaneously?

984


What is ado recordset?

920


What are the different ado.net namespaces are available in .net?

941


What is the role of data provider in ado.net?

939


What are the benefits of using ado.net?

946


Define executenonquery?

864


What is typed dataset ?

1105


Is it possible to load multiple tables in a Dataset?

999


Which architecture does Datasets follow?

985