Thread: SqlConnection Class

Use of SqlConnection Class

I would like to know about the 'SqlConnection' class. Why we use “SqlConnection class"? I think it may be related to the SQL database connection, but I am not sure on this. please give me some details about "SqlConnection class".

The SqlConnection class gives all the properties and methods requisite to make a connection to a SQL database.

Properties and Methods of the SqlConnection Class

Item Description Properties

• ConnectionString: Contains the database connection string

• ConnectionTimeout :Contains the timeout for the connection in seconds

• Database: Contains the name of the database to connect to

• DataSource: Contains the name of the connected server

• PacketSize: Contains the size of packets used to communicate with the server

• ServerVersion: Contains the version of SQL that the server is running State Contains
the state of the connection

• WorkstationId :Contains the NetBIOS identifier of the machine hosting the Web form Methods

• BeginTransaction(): Places the connection into a transaction and returns the newly
created SqlTransaction object

• ChangeDatabase(): Enables the developer to change to a different database programmatically

• Close(): Closes the connection to the current database

• CreateCommand(): Returns a new command object

• Open():Opens the connection to the database