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

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

543


What does executequery return?

527


How to add a check box or a dropdown list to a column in a datagrid?

544


What is a control toolbox?

509


What is an ADO.Net?

574






How to connect and retrieve data from database using dataset

543


What are the ado.net objects?

517


What are the advantages of using datalist?

515


How to creating a SqlCommand Object?

598


Explain the basic use of "dataview" and explain its methods.

542


What is a column variable?

507


What is the difference between linq and ado.net?

519


Explain the different row versions available in table?

556


Explain advantages of ado.net?

563


What is difference between datatable and dataset?

531