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 will you fill the gridview by using datatable object at runtime?

732


Explain advantages of ado.net?

783


What is microsoft ado.net?

753


What are the ado.net components?

734


What is the executescalar method?

757






What does ado stand for?

681


Define table relations?

724


Do you use stored procedure in ado.net?

754


Define data access layer?

684


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

723


Explain the different row versions available in table?

727


What is openrowset?

678


Explain the dataadapter class in ado.net?

843


Which database is the ado.net sql connection object designed for?

788


What is the difference between oledb sql server and oledbdotnet provider?

704