C# data table help

Question

I need some help with make a datatable from sql. Is it someone that can help me please. I'm a Newbie. But I want to make my own datatable from scratch in codebehind and now with the premade that is in Visual Studio.

Can someone please help me do this?

Answer 1

Here's probably the most basic approach, using a IDataReader (in this case, a SqlDataReader) to populate a DataTable

public DataTable MakeDataTable()
{    
    DataTable table = new DataTable();    
    using (SqlConnection conn = new SqlConnection("ConnectionStringHere"))
    {
        using (SqlCommand cmd = conn.CreateCommand())
        {
            cmd.Text = "SELECT * FROM MyTable";

            conn.Open();

            using (SqlDataReader rdr = cmd.ExecuteReader())
            {
                table.load(rdr);
            }
        }
    }
    return table;  
}

Answer 2

You need to use a SqlDataAdapter to fill the DataTable.

Try something like this:

DataTable dataTable = new DataTable();

using (SqlConnection connection = new SqlConnection(yourConnectionString))
{
    connection.Open();

    using (SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, connection))
    {        
        adapter.Fill(dataTable);
    }
}