What is ADO.NET?What are the key components of ADO.NET?What are the ADO.NET namespaces?What is the meaning of object pooling?What are the differences between ADO.NET and classic ADO?Explain the architecture of ADO.NET.?What is a Connection String in ADO.NET C#??How do you establish a database connection using ADO.NET?Explain the concept of Connection Pooling in ADO.NET C#.Differentiate between Object pooling and Connection pooling in C#?What is a DataReader in ADO.NET? Explain with C# example?What is the functionality of CommandBehavior.SchemaOnly?Why CommandBehavior.SingleResult flag is used in ADO.NET?What does CommandBehavior.SingleRow do in ADO.NET?How we can get multiple results by DataReader using same connection in C#?How can we force the connection object to close after my DataReader is closed?What is a DataSet in ADO.NET? Explain with C# example?What are typed and un-typed datasets in ADO.NET C#?Write down some of the characteristic of DataSet?What is the difference between dataSet and DataReader?Why is DataSet Slower than DataReader? Explain with Example.How does DataSet handle data in a disconnected environment?What is the Difference between connected and disconnected architectire?Explain HasChanges() method of DataSet in C#.Explain GetChanges() method with detaild C# Example.Explain RejectChanges() method with C# Example.Explain AcceptChanges() method with C# Example.What are the various methods provided by DataSet for XML in C#?What is the purpose of DataAdapter in ADO.NET?Explain the steps involved in retrieving data using DataAdapter.
Previous
Next

What is a Connection String in ADO.NET?

A connection string in ADO.NET is a critical element used to establish a connection between a C# application and a database. It acts as a configuration string that contains all the essential information needed to connect to a database. This includes details such as the address of the database server, the name of the database, authentication credentials (username and password), and any other connection-specific settings. Here's an example of using a connection string in C#:


using System.Data.SqlClient;

// Connection string example for Microsoft SQL Server
string connectionString = "Data Source=myServerAddress;Initial Catalog=DotNetUstadDb;User Id=myUsername;Password=myPassword;";

// Create a SqlConnection object using the connection string
SqlConnection connection = new SqlConnection(connectionString);

try
{
    // Open the connection
    connection.Open();

    // Connection is open, perform database operations here...
}
catch (SqlException ex)
{
    // Handle any exceptions that occur during connection or database operations
    Console.WriteLine("Error: " + ex.Message);
}
finally
{
    // Ensure the connection is closed when finished
    connection.Close();
}

In this example, the connection string includes the following key-value pairs:

Data Source:

Specifies the server address or name where the SQL Server database is located.

Initial Catalog:

Here we put the database name to whom we want to establish connection.

User Id:

Specifies the username to use for authentication.

Password:

This is the password for the username you are using in connection.

In this example, we first define the connection string, which contains the necessary information to connect to the SQL Server database. We then create a SqlConnection object using the connection string.

Next, we open the connection using the Open() method. Within the try block, you can perform various database operations, such as executing queries or commands.

If any exceptions occur during the connection or database operations, they are caught in the catch block, where you can handle or log the error appropriately.

Finally, the connection is closed using the Close() method in the finally block to ensure the resources are released.

It's important to note that the connection string in the example is specific to Microsoft SQL Server.

Previous
Next