Form Problem

[BD]

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

[RobinS]

Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

[=?UTF-8?B?U8WCYXdlaw==?=]

BD napisał(a):

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

Is the CustomerID and LocationID integers or strings ?. You can't
display integers directly in textbox, so it may be the reason.

best,
Slawomir

[BD]

SÅ‚awek wrote:

BD napisał(a):

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

Is the CustomerID and LocationID integers or strings ?. You can't
display integers directly in textbox, so it may be the reason.

best,
Slawomir

The CustomerID and LocationID are autonumber integers from a SQL
backend.

[BD]

RobinS wrote:

Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

I am using a remote server running MS SQL 2005 and visual studio pro
2005 for front end development. Yes, I am data-binding to the source.
However, my dataset nesting is not listing the subforms datatables in
the manner I am using them on this form. I think I will need to
develope a custom control to display this information but am unsure.

[RobinS]

"BD" <bw******@chart er.netwrote in message
news:11******** **************@ i80g2000cwc.goo glegroups.com.. .

>
RobinS wrote:

>Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11******* *************** @v33g2000cwv.go oglegroups.com. ..

Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc
related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc
related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid
views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

I am using a remote server running MS SQL 2005 and visual studio pro
2005 for front end development. Yes, I am data-binding to the source.
However, my dataset nesting is not listing the subforms datatables in
the manner I am using them on this form. I think I will need to
develope a custom control to display this information but am unsure.

Can you set up one dataset with all of the tables in it?
Because if you can do that, this should be a snap.

Let's say you can, and let's say you have \data_relations assigned
accordingly, you can bind the childgrids to the parent and
when the parent changes, the childgrids will show the children
that go with that parent.

Here's what you need:

A BindingSource for parent and each of the children.
I'm assuming parent = WorkOrderBindin gSource,
children = WorkOrder_child BindingSource, like
WorkOrder_Custo merBindingSourc e.

Populate the dataset with all the tables. I'm assuming the
constraints are there; if they aren't, you can add them
to the dataset.

myDataSet.Relat ions.Add("WorkO rder_Customers" ,
myDataSet.Table s("WorkOrder"). Columns("WorkOr derID"),
myDataSet.Table s("Customers"). Columns("WorkOr derID"));

(do for all children)

Set up the databindings:

//parent
WorkOrderBindin gSource.DataSou rce = myDataSet;
WorkOrderBindin gSource.DataMem ber = "WorkOrder" ; //name of table
WorkOrderIDText Box.DataBinding s.Add("Text", WorkOrderBindin gSource,
"WorkOrderI D"); //bind a text box; use the bindingsource
(etc)

//children

//set the binding source to the same one as the parent
WorkOrder_Custo merBindingSourc e.DataSource = WorkOrderBindin gSource;

//set the datamember to the fk joining the tables
WorkOrder_Custo merBindingSourc e.DataMember = "FK_Customers_W orkOrder";

//set the data source on the child view to its own binding source
CustomerDataGri dView.DataSourc e = WorkOrder_Custo mersBindingSour ce ;

(do same for all children)

Run it.

I'm not a C# programmer, so if I missed any semi-colons or got any
brackets wrong, my apologies.

Robin S.

[RobinS]

"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:Oo******** *************** *******@comcast .com...

>
"BD" <bw******@chart er.netwrote in message
news:11******** **************@ i80g2000cwc.goo glegroups.com.. .

>>
RobinS wrote:

>>Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11****** *************** *@v33g2000cwv.g ooglegroups.com ...
Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc
related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc
related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID '
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID '

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid
views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.

I am using a remote server running MS SQL 2005 and visual studio pro
2005 for front end development. Yes, I am data-binding to the
source.
However, my dataset nesting is not listing the subforms datatables in
the manner I am using them on this form. I think I will need to
develope a custom control to display this information but am unsure.

Can you set up one dataset with all of the tables in it?
Because if you can do that, this should be a snap.

Let's say you can, and let's say you have \data_relations assigned
accordingly, you can bind the childgrids to the parent and
when the parent changes, the childgrids will show the children
that go with that parent.

Here's what you need:

A BindingSource for parent and each of the children.
I'm assuming parent = WorkOrderBindin gSource,
children = WorkOrder_child BindingSource, like
WorkOrder_Custo merBindingSourc e.

Populate the dataset with all the tables. I'm assuming the
constraints are there; if they aren't, you can add them
to the dataset.

myDataSet.Relat ions.Add("WorkO rder_Customers" ,
myDataSet.Table s("WorkOrder"). Columns("WorkOr derID"),
myDataSet.Table s("Customers"). Columns("WorkOr derID"));

(do for all children)

Set up the databindings:

//parent
WorkOrderBindin gSource.DataSou rce = myDataSet;
WorkOrderBindin gSource.DataMem ber = "WorkOrder" ; //name of table
WorkOrderIDText Box.DataBinding s.Add("Text", WorkOrderBindin gSource,
"WorkOrderI D"); //bind a text box; use the bindingsource
(etc)

//children

//set the binding source to the same one as the parent
WorkOrder_Custo merBindingSourc e.DataSource = WorkOrderBindin gSource;

//set the datamember to the fk joining the tables
WorkOrder_Custo merBindingSourc e.DataMember = "FK_Customers_W orkOrder";

//set the data source on the child view to its own binding source
CustomerDataGri dView.DataSourc e = WorkOrder_Custo mersBindingSour ce ;

(do same for all children)

Run it.

I'm not a C# programmer, so if I missed any semi-colons or got any
brackets wrong, my apologies.

Robin S.

One other thing -- if you have something other than a grid for
the children, you can bind those to their binding source.

CustomerNameTex tBox.DataBindin gs.Add("Text",
WorkOrder_Custo merBindingSourc e, "CustomerName") ;

It's like magic!

Robin S.

[BD]

RobinS wrote:

"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:Oo******** *************** *******@comcast .com...

"BD" <bw******@chart er.netwrote in message
news:11******** **************@ i80g2000cwc.goo glegroups.com.. .

>
RobinS wrote:
Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11******* *************** @v33g2000cwv.go oglegroups.com. ..
Moving from MS Access to .Net using C# languag. Problem trying to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc
related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc
related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related by
'WorkOrderID'
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID'

Have successfully created child form "Work Order" with textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid
views.
Problem is have been unable to present 'Customer' and 'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.
I am using a remote server running MS SQL 2005 and visual studio pro
2005 for front end development. Yes, I am data-binding to the
source.
However, my dataset nesting is not listing the subforms datatables in
the manner I am using them on this form. I think I will need to
develope a custom control to display this information but am unsure.

Can you set up one dataset with all of the tables in it?
Because if you can do that, this should be a snap.

Let's say you can, and let's say you have \data_relations assigned
accordingly, you can bind the childgrids to the parent and
when the parent changes, the childgrids will show the children
that go with that parent.

Here's what you need:

A BindingSource for parent and each of the children.
I'm assuming parent = WorkOrderBindin gSource,
children = WorkOrder_child BindingSource, like
WorkOrder_Custo merBindingSourc e.

Populate the dataset with all the tables. I'm assuming the
constraints are there; if they aren't, you can add them
to the dataset.

myDataSet.Relat ions.Add("WorkO rder_Customers" ,
myDataSet.Table s("WorkOrder"). Columns("WorkOr derID"),
myDataSet.Table s("Customers"). Columns("WorkOr derID"));

(do for all children)

Set up the databindings:

//parent
WorkOrderBindin gSource.DataSou rce = myDataSet;
WorkOrderBindin gSource.DataMem ber = "WorkOrder" ; //name of table
WorkOrderIDText Box.DataBinding s.Add("Text", WorkOrderBindin gSource,
"WorkOrderI D"); //bind a text box; use the bindingsource
(etc)

//children

//set the binding source to the same one as the parent
WorkOrder_Custo merBindingSourc e.DataSource = WorkOrderBindin gSource;

//set the datamember to the fk joining the tables
WorkOrder_Custo merBindingSourc e.DataMember = "FK_Customers_W orkOrder";

//set the data source on the child view to its own binding source
CustomerDataGri dView.DataSourc e = WorkOrder_Custo mersBindingSour ce ;

(do same for all children)

Run it.

I'm not a C# programmer, so if I missed any semi-colons or got any
brackets wrong, my apologies.

Robin S.

One other thing -- if you have something other than a grid for
the children, you can bind those to their binding source.

CustomerNameTex tBox.DataBindin gs.Add("Text",
WorkOrder_Custo merBindingSourc e, "CustomerName") ;

It's like magic!

Robin S.

You are correct, once I nested tables into the same dataset, everything
worked the way I wanted. Thank you very much for your help.

BD

[RobinS]

"BD" <bw******@chart er.netwrote in message
news:11******** **************@ s80g2000cwa.goo glegroups.com.. .

>
RobinS wrote:

>"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:Oo******* *************** ********@comcas t.com...

>
"BD" <bw******@chart er.netwrote in message
news:11******** **************@ i80g2000cwc.goo glegroups.com.. .

RobinS wrote:
Are you using data binding? Are you using version 2003 or 2005?

Robin S.
-----------------
"BD" <bw******@chart er.netwrote in message
news:11****** *************** *@v33g2000cwv.g ooglegroups.com ...
Moving from MS Access to .Net using C# languag. Problem trying
to
duplicate form with structure as follows:
1. Main form 'Work Order' displayed as textboxes
2. subform 'Customers' textboxes showing name, address, etc
related
by 'CustomerID'
3. subform 'Locations' textboxes showing name, address, etc
related
by 'LocationID'
4. subform 'Material' on tabbed interface datasheet related
by
'WorkOrderID '
5. subform 'Labor' on tabbed interface datasheet related by
'WorkOrderID '

Have successfully created child form "Work Order" with
textboxes,
tabbed interface for 'Material' and 'Labor' records in datagrid
views.
Problem is have been unable to present 'Customer' and
'Location'
information in textboxes on the form related tables.

Again, thank you in advance for any help.
I am using a remote server running MS SQL 2005 and visual studio
pro
2005 for front end development. Yes, I am data-binding to the
source.
However, my dataset nesting is not listing the subforms datatables
in
the manner I am using them on this form. I think I will need to
develope a custom control to display this information but am
unsure.

Can you set up one dataset with all of the tables in it?
Because if you can do that, this should be a snap.

Let's say you can, and let's say you have \data_relations assigned
accordingly, you can bind the childgrids to the parent and
when the parent changes, the childgrids will show the children
that go with that parent.

Here's what you need:

A BindingSource for parent and each of the children.
I'm assuming parent = WorkOrderBindin gSource,
children = WorkOrder_child BindingSource, like
WorkOrder_Custo merBindingSourc e.

Populate the dataset with all the tables. I'm assuming the
constraints are there; if they aren't, you can add them
to the dataset.

myDataSet.Relat ions.Add("WorkO rder_Customers" ,
myDataSet.Table s("WorkOrder"). Columns("WorkOr derID"),
myDataSet.Table s("Customers"). Columns("WorkOr derID"));

(do for all children)

Set up the databindings:

//parent
WorkOrderBindin gSource.DataSou rce = myDataSet;
WorkOrderBindin gSource.DataMem ber = "WorkOrder" ; //name of table
WorkOrderIDText Box.DataBinding s.Add("Text", WorkOrderBindin gSource,
"WorkOrderI D"); //bind a text box; use the bindingsource
(etc)

//children

//set the binding source to the same one as the parent
WorkOrder_Custo merBindingSourc e.DataSource =
WorkOrderBindin gSource;

//set the datamember to the fk joining the tables
WorkOrder_Custo merBindingSourc e.DataMember =
"FK_Customers_W orkOrder";

//set the data source on the child view to its own binding source
CustomerDataGri dView.DataSourc e = WorkOrder_Custo mersBindingSour ce
;

(do same for all children)

Run it.

I'm not a C# programmer, so if I missed any semi-colons or got any
brackets wrong, my apologies.

Robin S.

One other thing -- if you have something other than a grid for
the children, you can bind those to their binding source.

CustomerNameTe xtBox.DataBindi ngs.Add("Text",
WorkOrder_Custo merBindingSourc e, "CustomerName") ;

It's like magic!

Robin S.

You are correct, once I nested tables into the same dataset,
everything
worked the way I wanted. Thank you very much for your help.

BD

You're welcome; I'm glad it helped!

Robin S.