how to build for loop for my code

Bahubali Gane

guys plz help me, i dont know how to build a for loop for my code

following is my code

dataGridView1.Rows.Add();

dataGridView1.Rows[0].Cells[0].Value = dt.Rows[0][0].ToString();

dataGridView1.Rows[0].Cells[1].Value = dt.Rows[0][1].ToString();

dataGridView1.Rows[0].Cells[2].Value = dt.Rows[0][2].ToString();

dataGridView1.Rows[0].Cells[3].Value = dt.Rows[0][3].ToString();

dataGridView1.Rows[0].Cells[4].Value = dt.Rows[0][4].ToString();

dataGridView1.Rows[0].Cells[5].Value = dt.Rows[1][4].ToString();

dataGridView1.Rows[0].Cells[6].Value = dt.Rows[2][4].ToString();

dataGridView1.Rows[0].Cells[7].Value = dt.Rows[3][4].ToString();

dataGridView1.Rows[0].Cells[8].Value = dt.Rows[0][5].ToString();

dataGridView1.Rows[0].Cells[9].Value = dt.Rows[0][6].ToString();

above code is for one data row, i have more than 1000 rows. i think it is possible through only for loop, please anybody help me, thank u in advance

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bahubali Gane10y ago
Thank u guys...
Vivek Bansod10y ago
Refer this link as well -

https://social.msdn.microsoft.com/Forums/office/en-US/94856ab5-f820-4fdf-87f2-a37d1f05792c/splist?forum=sharepointdevelopmentlegacy
Vivek Bansod10y ago
Can you share code - how you have implemented suggested code?

Columns cannot be accessed on DataRow however you can access them as DataTable[RowIndex].Columns

As said, you need use suggested logic as your code
Bahubali Gane10y ago
but still i didnt get correct ans....
Bahubali Gane10y ago
but still i didnt get correct ans....
Bahubali Gane10y ago
Thank you for replaying guys.. thank u so much....
Bahubali Gane10y ago
i am getting error

Error 1 'System.Data.DataRow' does not contain a definition for 'Columns' and no extension method 'Columns' accepting a first argument of type 'System.Data.DataRow' could be found (are you missing a using directive or an assembly reference?) C:\Users\Rohini\Documents\Visual Studio 2008\Projects\RTB\RTB\Form1.cs 55 52 RTB
Nishant Mittal10y ago
Hope this will help you....

For(int i=0;i
{
dataGridView1.Rows[0].Cells[i].Value = dt.Rows[0][i].ToString();
}
Vivek Bansod10y ago
Hi,

Try using loop similar to below. Below is just a logic - you can modify as you need.

for(int i=0;i< dbTable.Rows.Count;i++)
{
for(int j=0;j
{
dataGridView1.Rows[i].Cells[j].Value = dt.Rows[i][j].ToString();
}
}