Jeff

Jeff

  • NA
  • 1
  • 0

Establishing sequence numbers in a table

May 30 2007 6:34 AM

I need to insert  some sequence numbers into a table for use by another application.  The only way I could think of doing this was to use a data grid view to get the records in the sequence I want them by sorting the binding source as shown below.

this
.trunkMatrixBindingSource.Sort = "Depart_Time_Mins ASC"
;
this.trunk_MatrixTableAdapter.FillByScenario(this.linehaulDataSet.Trunk_Matrix);
int seqNo = 1;
for (int i = 0; i <= this.trunkMatrixDataGridView.RowCount - 1; i++)
{
this.trunkMatrixDataGridView.Rows[i].Cells["Depart_Seq_No"].Value = seqNo;
seqNo++;
}
this.trunk_MatrixTableAdapter.Update(this.linehaulDataSet.Trunk_Matrix);

This seems rather clumsy and I'm sure someone can tell me of a much better way of doing it.

More specifically it does not apply the sequence number to the record represented by the first row in the data grid.  I would really like to understand why this is. 

I have a number of other examples where data bindings appear not to get updated as I would expect/want them to.  So maybe I have a basic misunderstanding somewhere. 

Thanks for any help.


Answers (1)