Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is difference between ado and other data object?

906


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

1011


What is the difference between DataReader and DataSet in ADO.NET?

1153


Explain how do you connect to sql server database without using sqlclient?

1000


What is the difference between ado.net and entity framework?

1041


What is ado.net architecture?

922


What is ado recordset?

982


What is dbcontext and dbset in entity framework?

931


What are the advantages and disadvantages of using datalist?

1072


Describe briefly an ADO.NET Dataset ?

1078


Some important instruction regarding ADO.NET connection string ?

972


Which is faster entity framework or ado.net?

922


Does sqlclient and oledb class share the same functionality?

918


Define table relations?

969


What is the purpose of using adodb?

955