Form BindingContext object indexer problem?

[D. Yates]

Hi,

I retrieved the employee table from the Pubs database into a single dataset
called, dataSet12. I dropped two textbox controls and a datagrid control
onto the same form and bound the controls at design time to dataSet12's
employee table. Now I want to move through the data by pressing a
button....

This code will change the data in the text boxes:
this.BindingCon text[dataSet12, "employee"].Position += 1;

and this code will move the data in the datagrid:
this.BindingCon text[dataSet12.emplo yee].Position += 1;

If I do this, cm1 and cm2 are not equal:
CurrencyManager cm1 = (CurrencyManage r)
this.BindingCon text[dataSet12.emplo yee];
CurrencyManager cm2 = (CurrencyManage r) this.BindingCon text[dataSet12,
"employee"];

if (cm1 == cm2)
cm1.Position++;

cm1 and cm2 are never equal. Why are they different?
I fixed my problem by changing the design property of the datagrid from
dataGrid1.DataS ource = dataSet12.emplo yee;
dataGrid1.DataM ember = <blank>

to

dataGrid1.DataS ource = dataSet12;
dataGrid1.DataM ember = "employee";

and then this works:
this.BindingCon text[dataSet12, "employee"].Position += 1;

Again, my question is why did I have to do this and why aren't these equal:
this.BindingCon text[dataSet12, "employee"].Position += 1;
this.BindingCon text[dataSet12.emplo yee].Position += 1;
Personally, I would rather use:
this.BindingCon text[dataSet12.emplo yee].Position += 1;
since it doesn't require a internal table lookup. It is also the code shown
on page 328 of the MCAD/MCSD Self pace training kit for test 70-306/70-316.
The books example works because he is demonstrating runtime data binding and
he binds his text boxes with code that looks like this:
TextBox1.DataBi ndings.Add("Tex t", DataSet1.Custom ers, "CustomerID ");

Dave

[Bart Mermuys]

Hi,

"D. Yates" <fo****@hotmail .com> wrote in message
news:e3******** ******@TK2MSFTN GP14.phx.gbl...

Hi,

I retrieved the employee table from the Pubs database into a single
dataset called, dataSet12. I dropped two textbox controls and a datagrid
control onto the same form and bound the controls at design time to
dataSet12's employee table. Now I want to move through the data by
pressing a button....

This code will change the data in the text boxes:
this.BindingCon text[dataSet12, "employee"].Position += 1;

and this code will move the data in the datagrid:
this.BindingCon text[dataSet12.emplo yee].Position += 1;

If I do this, cm1 and cm2 are not equal:
CurrencyManager cm1 = (CurrencyManage r)
this.BindingCon text[dataSet12.emplo yee];
CurrencyManager cm2 = (CurrencyManage r) this.BindingCon text[dataSet12,
"employee"];

if (cm1 == cm2)
cm1.Position++;

cm1 and cm2 are never equal. Why are they different?
I fixed my problem by changing the design property of the datagrid from
dataGrid1.DataS ource = dataSet12.emplo yee;
dataGrid1.DataM ember = <blank>

to

dataGrid1.DataS ource = dataSet12;
dataGrid1.DataM ember = "employee";

and then this works:
this.BindingCon text[dataSet12, "employee"].Position += 1;

Again, my question is why did I have to do this and why aren't these
equal:
this.BindingCon text[dataSet12, "employee"].Position += 1;
this.BindingCon text[dataSet12.emplo yee].Position += 1;
Basicly that's how it is designed though it may be confusing. It's not
enough that both databindings end up with the same data, when you ask a
BindingContext for a CurrencyManager then you must use the exact same
DataSource and DataMember (excluding fieldname) then the ones you used for
the binding.

A BindingContext is basicly a map with DataSource+Data Member being the key
and BindingManagerB ase(CurrencyMan ager or PropertyManager ) being the value.
Each time you bind a list to some Control it needs a CurrencyManager to
maintain the position, so it checks whether the BindingContext already
contains a CurrencyManager for that DataSource+Data Member and if it does
then it uses the existing one, otherwise it creates a new CurrencyManager .
That should also explain why they can navigate together or independent.

So a combination of DataSource and DataMember(with out fieldname) is the key
but there is _no_ resolving to see whether this points to the same data or
not.


Personally, I would rather use:
this.BindingCon text[dataSet12.emplo yee].Position += 1;
since it doesn't require a internal table lookup. It is also the code
shown on page 328 of the MCAD/MCSD Self pace training kit for test
70-306/70-316. The books example works because he is demonstrating runtime
data binding and he binds his text boxes with code that looks like this:
TextBox1.DataBi ndings.Add("Tex t", DataSet1.Custom ers, "CustomerID ");
Yes, but if you use a typed DataSet then then the designer won't let you
bind TextBox's directly to a DataTable, it will always use the DataSet as
the DataSource.
HTH,
greetings

Dave