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

  1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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

Question Posted / sanjogita.lahiri

Answers were Sorted based on User's Feedback



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

Answer / srikanth r

The two key events are InfoMessage and StateChange events.

InfoMessage event occurs when informational message is
returned from data source that do not results in throwing
an exception.
StateChange event occurs when there is a change in
Connection to the data source.

Is This Answer Correct ?    23 Yes 1 No

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

Answer / 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

More ADO.NET Interview Questions

What is DataReader Object?

0 Answers  

Explain how do you connect to sql server database without using sqlclient?

0 Answers  

How to generate a single aggregate?

0 Answers  

How to retrieve the third table value from the data set?

2 Answers   Network Solutions,

How do you merge two datasets into the third dataset in a simple manner?

3 Answers   IBM,

What is the default provider in ado.net?

0 Answers  

Call a stored procedure from ado.net and pass parameter to it ?

7 Answers   Keane India Ltd, TCS,

What is Debug.write does?

1 Answers  

How do you implement locking concept for dataset?

0 Answers  

How can I retrieve two tables of data at a time by using data reader?

0 Answers  

What are all the different methods under sqlcommand?

0 Answers  

Which type of database is used while processing dynamic database?

1 Answers   Microsoft,

For more ADO.NET Interview Questions Click Here
Categories