what are the two key events for the sql connection class?
explain the differnce between the two.
- 2 Answers
- 8999 Views
- HCL, NIIT, Zensar, I also Faced
- E-Mail Answers
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
Why do we serialize data?
What is the default provider in ado.net?
Which is faster datareader or dataadapter?
Is bulk insert faster than insert?
What is partial class?
How do you merge 2 datasets into the third dataset in a simple manner?
What is sqldatareader in ado.net?
What is difference between connected and disconnected architecture in ado.net?
What is ado.net code?
How does ado.net work?
What is the difference between Dataset. clone and Dataset.copy?
What are the advantages of oledb compared with other classes?
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?
Which method in OLEDBAdapter is used to populate dataset with records?
What are good ado.net object to replace to ado recordset object.
