Prev: DataGrid & Horizontal Scroll Bar
Next: Bluetooth C# DLLs
From: 2139933 on 7 Dec 2007 05:20
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
From: Ginny Caughey [MVP] on 3 Jan 2008 11:49
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.

--
Ginny Caughey
Device Application Development MVP


<2139933(a)gmail.com> wrote in message
news:d562f1e4-ff86-4ebc-813e-6825d643bf39(a)o42g2000hsc.googlegroups.com...
> 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

 | 
Pages: 1
Prev: DataGrid & Horizontal Scroll Bar
Next: Bluetooth C# DLLs