Breaking News: Grepper is joining You.com. Read the official announcement!

c# sql command

SubZero answered on March 5, 2023 Popularity 6/10 Helpfulness 5/10

answer c# sql command

c# sql command

Comment

using System.Data.SqlClient;

// Establish a connection to the SQL Server database
string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True";
SqlConnection connection = new SqlConnection(connectionString);

// Open the connection
connection.Open();

// Define the SQL command to execute
string sql = "SELECT * FROM Customers";
SqlCommand command = new SqlCommand(sql, connection);

// Execute the SQL command and retrieve the results
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
    // Do something with the results
    string customerId = reader["CustomerId"].ToString();
    string companyName = reader["CompanyName"].ToString();
    // ...
}

// Close the reader and the connection
reader.Close();
connection.Close();

We then create a SqlCommand object that specifies the SQL query to execute (in this case, selecting all rows from the "Customers" table). We execute the command using the ExecuteReader() method, which returns a SqlDataReader object that we can use to iterate over the results.

Finally, we close the reader and the connection when we're done.

Popularity 6/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: c# command sql

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

c# sql command

Contents

More Related Answers

c# sql command

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.