DataGrid and SqlCeResultset in CF v2

[2139933]

Hi,

Help please to troubleshoot with SqlCeResultset and DataGrid in CF
v2.


I do so:


public System.Data.SqlServerCe.SqlCeResultSet CustsResulSet = null;


public SqlCeResultSet GetExecuteResultSet(string _comText, bool
_updatable)
{
SqlCeCommand cmd = new SqlCeCommand(_comText,
sqlCeConnection);
resultSetOptions = ResultSetOptions.Scrollable;
if (_updatable) resultSetOptions = (resultSetOptions |
ResultSetOptions.Updatable);
return cmd.ExecuteResultSet(this.resultSetOptions);



}


public void GetData()
{
CustsResulSe = GetExecuteResultSet("SELECT [Name] FROM
[Customs]",
false);
DataGrid.DataSource = CustsResulSet;
label1.Text = CustsResulSet.GetString(0);
label2.Text =
CustsResulSet.GetString(DataGrid.CurrentRowIndex);


}


After performance GetData I see that in DataGrid cursor stands on
first row,
but label1 and label2 show data from last seen row, why this can
occur?
How me correctly synchronize positions of cursor in DataGrid and
SqlCeResultset?

Many thanked,


Alexander

 

[Ginny Caughey [MVP]]

Alexander,

It looks like you want to databind the labels to something in the current
row of the SqlCeResultset. I don't think I've ever tried this with a label,
but for a TextBox you can use TextBox.DataBindings.Add("text",
theResultSetOrResultSetView, theColumnNameAsAString) instead of setting the
Text property directly. This may work for labels too - I just never tried
it.