Interested to Buy Any Domain ? << Click Here >> for more details...
what are the two key events for the sql connection class?
explain the differnce between the two.
- 2 Answers
- 10133 Views
- HCL, NIIT, Zensar, I also Faced
- E-Mail Answers
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 are the disadvantages of using datalist?
can we change the data in dataset? if yes what is the process?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
How to add a javaScript function in a datagrid?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is ado.net tutorial?
Which is the feature of ado.net?
Which method is used by command class to execute SQL statements that return single value?
What is an orm, and why would you use one instead of plain old ado.net?
How to work with disconnected data - the dataset and sqldataadapter?
What is aggregate root?
What are the methods of XML dataset object?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
