DaniWeb IT Discussion Community - How to add rows from dataset to datagridview

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- C# (http://www.daniweb.com/forums/forum61.html)

- - How to add rows from dataset to datagridview (http://www.daniweb.com/forums/thread53114.html)

How to add rows from dataset to datagridview

dgClient.Columns.Add("client", "Client")

dgClient.Columns("client").Width = 150

dgClient.Columns.Add("comments", "Comments")

dgClient.Columns("comments").Width = 250



Dim i As Integer

For i = 0 To dsClient.Tables("TableClient").Rows.Count - 1

dgClient.Rows.Add()

dgClient.Rows(i).Cells("client").Value = dsClient.Tables("TableClient").Rows(i).Item("Client")

dgClient.Rows(i).Cells("comments").Value = dsClient.Tables("TableClient").Rows(i).Item("Comments")

Next

How I can do above using C#

Thanks in advance

Re: How to add rows from dataset to datagridview

Quote:

Originally Posted by Swapnil Palande (Post 245573)

Hi all,

Please solve my Problem:

I have DataGridView and Dataset. I want to add data from dataset to datagridview row by row and not by using DataGridView.DataSource method.

For ex. following is the way to do the same using Vb.net

dgClient.Columns.Add("client", "Client")
dgClient.Columns("client").Width = 150
dgClient.Columns.Add("comments", "Comments")
dgClient.Columns("comments").Width = 250

Dim i As Integer
For i = 0 To dsClient.Tables("TableClient").Rows.Count - 1
dgClient.Rows.Add()
dgClient.Rows(i).Cells("client").Value = dsClient.Tables("TableClient").Rows(i).Item("Client")
dgClient.Rows(i).Cells("comments").Value = dsClient.Tables("TableClient").Rows(i).Item("Comments")
Next

How I can do above using C#

Thanks in advance

Hi Swap, you will have to do some databinding and invoke the CurrencyManager as well. There is also a BindingManagerBase class that should prove to be usefull as well.
See www.akadia.com/services/dotnet_databinding.html

See ya
edreflak

Re: How to add rows from dataset to datagridview

here is the equivalent code that u have given in VB, but plz plz this is my first time that i have writen code for the datagridview in C#. i m begginer too, to seach and learn abt datagridview when i found your problem so i tried on it . if it is correct so plz tell me. otherwise sorry for disturbing u .

conString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=True";

            con = new SqlConnection(conString);

            con.Open();

            string quryString = " select * from Employees";

            da = new SqlDataAdapter(quryString, con);

            ds = new DataSet();

            da.Fill(ds, "Emp");

            //dataGridView1.DataSource = ds.Tables["Emp"];

            dataGridView1.Columns.Add("EmpID", "ID");

            dataGridView1.Columns.Add("FirstName", "FirstName");

            dataGridView1.Columns.Add("LastName", "LastName");

            int row = ds.Tables["Emp"].Rows.Count - 1;

            for (int r = 0; r<= row; r++)

            {

                dataGridView1.Rows.Add();

                dataGridView1.Rows[r].Cells[0].Value = ds.Tables["Emp"].Rows[r].ItemArray[0];

                dataGridView1.Rows[r].Cells[1].Value = ds.Tables["Emp"].Rows[r].ItemArray[1];

                dataGridView1.Rows[r].Cells[2].Value = ds.Tables["Emp"].Rows[r].ItemArray[2];

            }

                





            con.Close();

        }