Load table data to the Data Grid

[Mr]

hi ..


Previously I used following code to fill the Data Grid Microsoft's own
But it does not work with the new tool Grid View

myconn = New SqlConnection(constr)
       myconn.Open()
       mycomm = New SqlCommand("Select * from tab1 ", myconn)
       reader = mycomm.ExecuteReader
       reader.Read()
       DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value = reader(0).ToString.ToUpper
       DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value = reader(1).ToString.ToUpper
       DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(2).Value = reader(2).ToString.ToUpper
       DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(3).Value = reader(3).ToString.ToUpper
       DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(4).Value = reader(4).ToString.ToUpper
       reader.Close()
       myconn.Close()

What is the solution؟!
THX

[Dess | Tech Support Engineer, Principal]

Hello,

Thank you for contacting Telerik Support.

You can populate our RadGridView using the following code snippet:

public Form1()
{
    InitializeComponent();

    for (int i = 0; i < 18; i++)
    {
        GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("Col" + i);
        radGridView1.MasterTemplate.Columns.Add(textBoxColumn);
    }

    using (SqlConnection connection = new SqlConnection("connection string"))
    {
        connection.Open();
        string queryString = @"Select * from Employees";
        SqlCommand command = new SqlCommand(queryString, connection);
        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            GridViewRowInfo row = radGridView1.Rows.NewRow();
            for (int i = 0; i < radGridView1.Columns.Count; i++)
            {
                row.Cells[i].Value = reader[i];
            }
            radGridView1.Rows.Add(row);
        }
        reader.Close();
    }
}

However, our Tutorial: Binding to DataTable or DataSet help article is quite useful about this.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

[Mr]

Thank you