|
|
You're in the
dotnet windows forms databinding
group:How to do batch-update from DataGrid?
dotnet windows forms databinding:
I have 2 tables: Products (ProductID, ProductName) and Inventory(ProductID, Qty). I must display table Inventory in DataGrid (like in Excel) in order to user can working with it (input Qty for each Product). In order to the sheet look more friendly, I make o view Inventory_View( ProductID, ProductName, Qty). Now bind this view to the datagrid dg.DataSource = ds; dg.DataMember = "Inventory_View"; .... Now, user can enter Qty for every product on datagrid. After that, when user clicks on button Save, I must update the table Inventory. Pls help me to do this update. Thanks. -- Contact: Bauman Moscow State Technical University Russia, Moscow 105005 Tel: +7915-426-6272 ICQ: 160-223-078 YM: Chipheo2k
Hi,
[quoted text, click to view] "Duong Nguyen" <Duongnguyen@mail.ru> wrote in message news:%23DSkgAv3GHA.508@TK2MSFTNGP06.phx.gbl... > Hello! > I have 2 tables: Products (ProductID, ProductName) and > Inventory(ProductID, Qty). I must display table Inventory in DataGrid > (like in Excel) in order to user can working with it (input Qty for each > Product). In order to the sheet look more friendly, I make o view > Inventory_View( ProductID, ProductName, Qty). Now bind this view to the > datagrid > > dg.DataSource = ds; > dg.DataMember = "Inventory_View"; Some options: 1) Don't load a view, instead load the Product table and Inventory table, add the right relation and add an expression column, eg: DataSet ds = ...contains loaded Inventory and Product table...; ds.Relations.Add("relProdInv", ds.Tables["Product"].Columns["ID"] /*PK*/, ds.Tables["Inventory"].Columns["ProductID"] /*FK*/ ); ds.Tables["Inventory"].Columns.Add("ProductName", typeof(string), "Parent(relProdInv).ProductName"); Then display the Inventory table, it will also show the ProductName, you only need to update the Inventory table then. Note that in NET1.1 it's possible the update (DataAdapter.Update) will fail if there are expression columns, so you need to remove them before and re-add them afterwards, bit annoying but it works. 2) Use your Inventory_View and setup an appropriate UpdateCommand on the Inventory_View DataAdapter which should only include fields from the Inventory Table. If you have no idea how to do this, then use the designer to setup an DataAdapter for the Inventory Table and have a look at the designer generated code for the UpdateCommand. If you have any problems, please mention what framework you're using 1.1 or 2.0 ? HTH, Greetings [quoted text, click to view] > ... > Now, user can enter Qty for every product on datagrid. After that, when > user clicks on button Save, I must update the table Inventory. Pls help me > to do this update. > Thanks. > > > -- > Contact: > Bauman Moscow State Technical University > Russia, Moscow 105005 > Tel: +7915-426-6272 > ICQ: 160-223-078 > YM: Chipheo2k >
Hi,
[quoted text, click to view] "Duong Nguyen" <Duongnguyen@mail.ru> wrote in message news:e9%234pI03GHA.1300@TK2MSFTNGP05.phx.gbl... > Hi, > thanks for your help! > I want to ask you if I use typed DataSet, so I can add the relation by the > visual designer, Just to be clear, Products must be the parent and Inventory the child. [quoted text, click to view] > but how can I add the expression column? You still didn't mentioned if you're using NET1.1 or NET2.0, but i think it's pretty much the same: select your table inside the visual designer, then click on the empty row and start typing to add a column, then open "Property Window" and set the expression. HTH, Greetings [quoted text, click to view] > Do I need add it programmatically? > > > > -- > Contact: > Bauman Moscow State Technical University > Russia, Moscow 105005 > Tel: +7915-426-6272 > ICQ: 160-223-078 > YM: Chipheo2k > "Bart Mermuys" <b-m.NOSPAM@pandora.be> wrote in message > news:mK8Rg.91734$ST7.1312833@phobos.telenet-ops.be... >> Hi, >> >> "Duong Nguyen" <Duongnguyen@mail.ru> wrote in message >> news:%23DSkgAv3GHA.508@TK2MSFTNGP06.phx.gbl... >>> Hello! >>> I have 2 tables: Products (ProductID, ProductName) and >>> Inventory(ProductID, Qty). I must display table Inventory in DataGrid >>> (like in Excel) in order to user can working with it (input Qty for each >>> Product). In order to the sheet look more friendly, I make o view >>> Inventory_View( ProductID, ProductName, Qty). Now bind this view to the >>> datagrid >>> >>> dg.DataSource = ds; >>> dg.DataMember = "Inventory_View"; >> >> Some options: >> >> 1) >> Don't load a view, instead load the Product table and Inventory table, >> add the right relation and add an expression column, eg: >> >> DataSet ds = ...contains loaded Inventory and Product table...; >> ds.Relations.Add("relProdInv", >> ds.Tables["Product"].Columns["ID"] /*PK*/, >> ds.Tables["Inventory"].Columns["ProductID"] /*FK*/ ); >> >> ds.Tables["Inventory"].Columns.Add("ProductName", typeof(string), >> "Parent(relProdInv).ProductName"); >> >> Then display the Inventory table, it will also show the ProductName, you >> only need to update the Inventory table then. Note that in NET1.1 it's >> possible the update (DataAdapter.Update) will fail if there are >> expression columns, so you need to remove them before and re-add them >> afterwards, bit annoying but it works. >> >> >> 2) >> Use your Inventory_View and setup an appropriate UpdateCommand on the >> Inventory_View DataAdapter which should only include fields from the >> Inventory Table. If you have no idea how to do this, then use the >> designer to setup an DataAdapter for the Inventory Table and have a look >> at the designer generated code for the UpdateCommand. >> >> >> If you have any problems, please mention what framework you're using 1.1 >> or 2.0 ? >> >> HTH, >> Greetings >> >> >>> ... >>> Now, user can enter Qty for every product on datagrid. After that, when >>> user clicks on button Save, I must update the table Inventory. Pls help >>> me to do this update. >>> Thanks. >>> >>> >>> -- >>> Contact: >>> Bauman Moscow State Technical University >>> Russia, Moscow 105005 >>> Tel: +7915-426-6272 >>> ICQ: 160-223-078 >>> YM: Chipheo2k >>> >> >> > >
Hi,
thanks for your help! I want to ask you if I use typed DataSet, so I can add the relation by the visual designer, but how can I add the expression column? Do I need add it programmatically? -- Contact: Bauman Moscow State Technical University Russia, Moscow 105005 Tel: +7915-426-6272 ICQ: 160-223-078 YM: Chipheo2k [quoted text, click to view] "Bart Mermuys" <b-m.NOSPAM@pandora.be> wrote in message news:mK8Rg.91734$ST7.1312833@phobos.telenet-ops.be... > Hi, > > "Duong Nguyen" <Duongnguyen@mail.ru> wrote in message > news:%23DSkgAv3GHA.508@TK2MSFTNGP06.phx.gbl... >> Hello! >> I have 2 tables: Products (ProductID, ProductName) and >> Inventory(ProductID, Qty). I must display table Inventory in DataGrid >> (like in Excel) in order to user can working with it (input Qty for each >> Product). In order to the sheet look more friendly, I make o view >> Inventory_View( ProductID, ProductName, Qty). Now bind this view to the >> datagrid >> >> dg.DataSource = ds; >> dg.DataMember = "Inventory_View"; > > Some options: > > 1) > Don't load a view, instead load the Product table and Inventory table, add > the right relation and add an expression column, eg: > > DataSet ds = ...contains loaded Inventory and Product table...; > ds.Relations.Add("relProdInv", > ds.Tables["Product"].Columns["ID"] /*PK*/, > ds.Tables["Inventory"].Columns["ProductID"] /*FK*/ ); > > ds.Tables["Inventory"].Columns.Add("ProductName", typeof(string), > "Parent(relProdInv).ProductName"); > > Then display the Inventory table, it will also show the ProductName, you > only need to update the Inventory table then. Note that in NET1.1 it's > possible the update (DataAdapter.Update) will fail if there are expression > columns, so you need to remove them before and re-add them afterwards, bit > annoying but it works. > > > 2) > Use your Inventory_View and setup an appropriate UpdateCommand on the > Inventory_View DataAdapter which should only include fields from the > Inventory Table. If you have no idea how to do this, then use the > designer to setup an DataAdapter for the Inventory Table and have a look > at the designer generated code for the UpdateCommand. > > > If you have any problems, please mention what framework you're using 1.1 > or 2.0 ? > > HTH, > Greetings > > >> ... >> Now, user can enter Qty for every product on datagrid. After that, when >> user clicks on button Save, I must update the table Inventory. Pls help >> me to do this update. >> Thanks. >> >> >> -- >> Contact: >> Bauman Moscow State Technical University >> Russia, Moscow 105005 >> Tel: +7915-426-6272 >> ICQ: 160-223-078 >> YM: Chipheo2k >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |