what are the two key events for the sql connection class?
explain the differnce between the two.
Answers were Sorted based on User's Feedback
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 |
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 |
What is Dataset Object?
What is a control toolbox?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What are all the different authentication techniques used to connect to MS SQL Server?
Differnce between Stored procedure and user defined functions?
17 Answers Microsoft, Symphony,
What is ole db and odbc?
What are the difference between readonly vs. Const?
What you mean by filtering of data?
What are the different row versions available in table?
What are different types of Commands available with DataAdapter ?
make a login control??
What is ole in excel?