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 acid in ado.net?
Which control of the BindingNavigator returns the current position within the data source?
What is data view and variable view?
What is connection string?
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?
What is the use of SqlCommandBuilder?
Explain how to pass multiple tables in datasets simultaneously?
What is ado recordset?
What are the different ado.net namespaces are available in .net?
What is the role of data provider in ado.net?
What are the benefits of using ado.net?
Define executenonquery?
What is typed dataset ?
Is it possible to load multiple tables in a Dataset?
Which architecture does Datasets follow?