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
- 10262 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 |
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?
Define isolation?
What are datareaders?
What is the difference between Datareader and Dataset?
How can you implement sub data grid in a master datagrid?
What are three methods for displaying data in a syncfusion datagrid
What is ado circle?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
What is the difference between ADO and ADO.Net?
How to identify the updated rows in a dataset?
what is a dataview?why is it used for?
-
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)
