Right LAST Problem i have.

need to edit the data from the table:

using the code below but getting got a little bug in it i not been able to work out yet! any help would be great

code:

DBConn.OleDbConns objConn = new DBConn.OleDbConns();
            OleDbConnection objOleDbConn = objConn.OpenReadConn();
            OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
            myDataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM "+dtable+"",objOleDbConn);
            OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter);

            DataSet custDS = new DataSet();
            myDataAdapter.Fill(custDS,"+dtable+");
            myDataGrid.DataSource=custDS;



        string number1, number2, number3, number4, number5, number6;




    string key = myDataGrid.DataKeys[e.Item.ItemIndex].ToString();



    TextBox tb;


    tb = (TextBox)(e.Item.Cells[3].Controls[0]);
    number1 = tb.Text;


    tb = (TextBox)(e.Item.Cells[4].Controls[0]);
    number2 = tb.Text;


    tb = (TextBox)(e.Item.Cells[5].Controls[0]);
    number3 = tb.Text;

    tb = (TextBox)(e.Item.Cells[6].Controls[0]);
    number4 = tb.Text;

    tb = (TextBox)(e.Item.Cells[7].Controls[0]);
    number5 = tb.Text;

    tb = (TextBox)(e.Item.Cells.Controls[0]);
    number6 = tb.Text;


// have the problem is here
    custDS.Tables["+dtable+"].Rows r;
    r = custDS.Tables["+dtable+"].FindBylastname(key);

    // Updates the dataset table.

    r.number1= number1;
    r.number2 = number2;
    r.number3 = number3;
    r.number4= number4;
    r.number5 = number5;
    r.number6= number6;

    // Calls a SQL statement to update the database from the dataset


    myDataAdapter.Update(custDS,"+dtable+");

    // Takes the DataGrid row out of editing mode
    myDataGrid.EditItemIndex = -1;

    // Refreshes the grid
    myDataGrid.DataBind();
            objConn.CloseConn(objOleDbConn);


getting the error that r need a ; but already got one :S ????

thanks for ur time and help

// have the problem is here
custDS.Tables["+dtable+"].Rows r;

What is that "r" in there for?

Maybe do you mean that to be:

System.Data.DataRowCollection r;

-Peter