Lookup in gridview
in [VB.NET]
|
From: John on 1 Jul 2008 17:37 Hi I have a gridview bound to a backend table A via dataset/data adapter. A drop down is bound to a second table B. When user selects a value form drop down I want to lookup another column in table B based on value selected from drop down and assign the lookup value to a column in gridviw. How can I pick the value selected by user and do the lookup from table B? Thanks Regards
From: Cor Ligthert[MVP] on 1 Jul 2008 23:15 John, A gridview does not work on a Windows form, therefore are you sure that it is a gridview, because that is an ASPNET control. Cor "John" <info(a)nospam.infovis.co.uk> schreef in bericht news:O76ysK82IHA.4928(a)TK2MSFTNGP04.phx.gbl... > Hi > > I have a gridview bound to a backend table A via dataset/data adapter. A > drop down is bound to a second table B. When user selects a value form > drop down I want to lookup another column in table B based on value > selected from drop down and assign the lookup value to a column in > gridviw. How can I pick the value selected by user and do the lookup from > table B? > > Thanks > > Regards > >
From: John on 2 Jul 2008 06:48 DataGridView is available on WinForm in vs2008. I don't understand what you mean. Regards "Cor Ligthert[MVP]" <notmyfirstname(a)planet.nl> wrote in message news:622D4A96-6202-4175-9C9C-ED9893FF43AC(a)microsoft.com... > John, > > A gridview does not work on a Windows form, therefore are you sure that it > is a gridview, because that is an ASPNET control. > > Cor > > "John" <info(a)nospam.infovis.co.uk> schreef in bericht > news:O76ysK82IHA.4928(a)TK2MSFTNGP04.phx.gbl... >> Hi >> >> I have a gridview bound to a backend table A via dataset/data adapter. A >> drop down is bound to a second table B. When user selects a value form >> drop down I want to lookup another column in table B based on value >> selected from drop down and assign the lookup value to a column in >> gridviw. How can I pick the value selected by user and do the lookup from >> table B? >> >> Thanks >> >> Regards >> >> >
From: ElFer on 2 Jul 2008 07:41 Use "SelectedValue" property from ComboBox "John" wrote: > DataGridView is available on WinForm in vs2008. I don't understand what you > mean. > > Regards > > "Cor Ligthert[MVP]" <notmyfirstname(a)planet.nl> wrote in message > news:622D4A96-6202-4175-9C9C-ED9893FF43AC(a)microsoft.com... > > John, > > > > A gridview does not work on a Windows form, therefore are you sure that it > > is a gridview, because that is an ASPNET control. > > > > Cor > > > > "John" <info(a)nospam.infovis.co.uk> schreef in bericht > > news:O76ysK82IHA.4928(a)TK2MSFTNGP04.phx.gbl... > >> Hi > >> > >> I have a gridview bound to a backend table A via dataset/data adapter. A > >> drop down is bound to a second table B. When user selects a value form > >> drop down I want to lookup another column in table B based on value > >> selected from drop down and assign the lookup value to a column in > >> gridviw. How can I pick the value selected by user and do the lookup from > >> table B? > >> > >> Thanks > >> > >> Regards > >> > >> > > > > >
From: Cor Ligthert[MVP] on 2 Jul 2008 13:06
John, > DataGridView is available on WinForm in vs2008. I don't understand what > you mean. > As well is the combobox, but the GridView as in your original post and in the subject of these messages is like the DropDown in your message not both are ASPNET controls. So what kind of help you want as you don't even try to describe your problem well? I saw that you probably was not meaning the GridView as you asked your question about and the dropdown because of the many crosspost you had made which in that windowsforms. But as most of us, we want to help people but than we expect that the poster at least takes some time to describe his problem well. Cor |