For the comments I made above ... Here are the solutions
For each row in the datatable
For Each dr As DataRow In dtnew.Rows
DataGridView1.Rows.Add(dr("col1"), dr("Col2"), dr("Col3"), dr("Col4"), dr("Col5"), dr("Col6"), dr("Col7"), dr("Col8"))
Next
Parameterized Query is something like below
Dim cm As New iDB2Command("SELECT * FROM TABLE Where Column=@PrmColumnval", cn)
cm.Parameters.Add("@PrmColumnval", iDB2DbType.iDB2VarChar).Value = Value
You can convert these to C#.