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
