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 ado.net objects?
What is the use of sqldatareader class?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
5 Answers IBM, Veegyapan Impacts,
What is the usage of the dataset object in ado.net?
what is the syntax code to oledb to connect oracle
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
How is entity framework different from ado.net?
How to work with disconnected data - the dataset and sqldataadapter?
What is a dynaset in access?
What are the different ado.net namespaces?
What is Serialization in .NET? what are the types of Serialization?
Explain how to pass multiple tables in datasets simultaneously?
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)