Help: Programmatically Update Data From An SQLDataSource (C#)

ello all

 Would someone be so kind as to save me from getting balder through pulling my hair out.

My aim is to extract data from a database using SQLDataSource, then edit the data and update the database using the SQLDataSource.

I have achieve the problem of retrieving the data from the sqlDataSource:
DataView openRemindingSeats = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
        //Int32 openRemindingSeats = SqlDataSource2.Select(DataSourceSelectArguments.Empty), DataView;

        foreach (DataRowView rowProduct in openReminding)
        {
            //Output the name and price
            lbl_NumOfSeatsLeft.Text = rowProduct["Remaining"].ToString();

        }

Within the sqlDataSource the sql code is as follows:
SELECT [refNumber], [refRemaining] FROM [refFlights] WHERE ([refNumber] = @Number)

So at the moment my problems is being able to edit and update data to the same SELECTed data.
Thank you for any help that you might have...

SynDrome