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



what are the two key events for the sql connection class? explain the differnce between the two...

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

what are the two key events for the sql connection class? explain the differnce between the two...

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

Post New Answer

More ADO.NET Interview Questions

What is the difference between Dataset. clone and Dataset.copy?

0 Answers  


What are the data providers used in ado.net

0 Answers  


What is sqldatareader?

0 Answers  


What is ado.net connection?

0 Answers  


Differentiate between Dataset and Recordset.

2 Answers  






Explain what a diffgram is and its usage ?

2 Answers  


What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?

3 Answers   Fulcrum Logic, Merrill Lynch,


What are the uses of Stored Procedure?

0 Answers  


What do you know about ADO.NET's objects and methods?

0 Answers   NA,


What is ado.net architecture?

0 Answers  


What is difference between datagridview and datagrid control in winforms?

0 Answers  


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

0 Answers   EDS,


Categories