How to Read SQL Table Data into a C# DataTable?

Reading SQL Table Data into a C# DataTable

When working with SQL databases and .NET applications, the need to retrieve data from a SQL table into a C# DataTable often arises. In this article, we will delve into how to accomplish this task.

To commence, you will require a DataTable object that will serve as the receptacle for the data from the SQL table. Subsequently, you will need to establish a connection with the database using a connection string and a SQL command to retrieve the desired data.

At this point, you will instantiate a SqlDataAdapter, a bridge between the database and your C# application. The Fill method of the SqlDataAdapter is pivotal in executing the query against the database and populating the DataTable with the result set.

Once the data is successfully retrieved, you can leverage the DataTable object to manipulate or process the data as required within your C# application.

Here is a code snippet that illustrates the approach:

using System;
using System.Data;
using System.Data.SqlClient;

public class PullDataTest
{
    private DataTable dataTable = new DataTable();

    public void PullData()
    {
        string connString = "your connection string here";
        string query = "select * from table";

        SqlConnection conn = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand(query, conn);
        conn.Open();

        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dataTable);

        conn.Close();
        da.Dispose();
    }
}

By adhering to this methodology, you can effectively and effortlessly read SQL table data into a C# DataTable, offering seamless data integration between your SQL database and your .NET applications.

The above is the detailed content of How to Read SQL Table Data into a C# DataTable?. For more information, please follow other related articles on the PHP Chinese website!