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
What is ado object model?
How to pass values into a datatable?
Which property is used to check whether a DataReader is closed or opened?
What is a string variable?
Define isolation?
What is dao and ado?
What does executenonquery () method return?
Explain all the classes those are used for database connections between sql server and asp.net?
What is the provider being used to access oracle database?
What is execute reader in ado.net?
What provider ado.net use by default? Explain the role of data provider in ado.net?
Can you explain how to enable and disable connection pooling?
What is the difference between a datareader and a dataset?
Difference between sqlcommand and sqlcommandbuilder?
What is openrowset?