Hi Roland,

Bonnie pointed out to change the line of code that sets the Position to after the SetDataBindings line of code. This is what you need to do to get your grid to highlight the correct row. I posted the lines of code incorrectly. Sorry for the confusion.

>Hi Cathi,
>
>I tried the following and it did not seem to work.
>
> Me.SqlDataAdapter1.Fill(Personnel01_Ds1, "Personnel")
> Me.BindingContext(Me.Personnel01_Ds1, "Personnel").Position = 0
> If Personnel01_Ds1.Tables("Personnel").Rows.Count > 0 Then
> Me.dgPersonnel.SetDataBinding(Personnel01_Ds1, "Personnel")
> Else
> Me.dgPersonnel.DataBindings.Clear()
> End If
>
>The datagrid row position (the row > selector) still was on another position down the grid. Not on the first row.
>
>Any suggestions?
>
>Hope you had a good New Year!
>
>Thanks
>Roland
>
>========================================================================
>
>
>>Hi Roland,
>>
>>You want to make sure you are using the DataBinding methods of the DataGrid. After you retrieve the contents of the DataSet (and you have records retrieved), you should call the SetDataBinding method of the DataGrid like below:
>>
>>

>>// Sets the Binding position
>>this.BindingContext[this.MyDataSet, "MyDataTable"].Position = 0;
>>
>>if (MyDataSet.Tables["MyDataTable"].Rows.Count > 0)
>>{
>>    this.grdOrders.SetDataBinding(MyDataSet, MyDataTable);
>>}
>>else
>>{
>>    this.grdOrders.DataBindings.Clear();
>>}
>>

>>
>>If you have Kevin McNeish's .NET book, in chapter 9 he discusses binding techniques and the sample application uses the above databinding.
>>
>>
>>>Hi,
>>>
>>>I have an windows forms app in VB.net using SqlConn/SqlDa/Datasets generated by the wizards.
>>>
>>>The first thing that I do is have the user enter in a search field and then clear and fill the dataset using parameters. The grid shows the desired rows. OK so far, but the second search (clear / fill) produces a dataset with the row pointer pointing at a different row then the first row of the grid.
>>>
>>>How do I position the row pointer to point to the first row of the newly genrated grid / dataset instead of randomly pointing to other than the first row?
>>>
>>>Thanks
>>>Roland