I've created a datagrid and populated it. Now I would like to loop through each row in the datagrid, and save the values in columns 1 and 2 so I can pass the values to a stored procedure. I haven't been successful in finding the code construct for doing this. Any suggestions?

Hi,
As another beginner I have found datagrid difficult to use.
However I assume you have bound the data grid to some data of some sort? If so just extract what you need from the array, or whatever it's bound to, and use that.
If the datagrid is not bound to some data I would be interested to know how you did it.
Good luck
Chris

Had a similar problem/requirement in C# (using .NET 1.1):

// Assumes you have DataView DView
// DataView has a DataTable getter/setter
System.Data.DataTable DTable = DView.Table;

// Use DataRow collection in DataTable to loop
foreach (DataRow DRow in DTable.Rows)
{
  // My DTable has a column name "SampleId",
  // Yours will obviously be different...
  Console.WriteLine("Column Value :" + DRow["SampleId"].ToString());

  // You can also use array-type indexing, to get the
  // correct column value from the current row
  // As always, indices start with 0...
  Console.WriteLine("Column Value :" + DRow[0].ToString());
}

Found this link useful, too: http://aspalliance.com/6_Summary_Row..._of_Techniques

Good luck...

Hi,

In the below code myTable is a DataTable which is underlying the datagrid.

for (i = 0; i <= myTable.Rows.Count - 1;i++)
        {
            if (Convert.ToDouble(myTable.Rows[i][1]) ==0)
            { Amt = Convert.ToDouble(myTable.Rows[i][2]) * (-1);
            }
            else
            {
                Amt = Convert.ToDouble(myTable.Rows[i][1]);}
                prmTcode.Value = VouNo;
                prmTdate.Value = Tdate;
                prmAccName.Value = myTable.Rows[i][0];
                prmTamt.Value = Amt;
                prmCat.Value = PrivateTransactionCat;
                myCommand.ExecuteNonQuery();
        }// for end
        myTrans.Commit();
        MessageBox.Show("Transaction Written to Database");
    }// end try
    catch (SqlException ex)
    {
        myTrans.Rollback();
        MessageBox.Show("Could not Add Transaction to Database");
    }
    finally
    {
    myConnection.Close();
    }

Database programming usingVisual Basic 2005