473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Lookup in gridview

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
Jul 1 '08 #1
6 1836
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" <in**@nospam.infovis.co.ukschreef in bericht
news:O7**************@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

Jul 2 '08 #2
DataGridView is available on WinForm in vs2008. I don't understand what you
mean.

Regards

"Cor Ligthert[MVP]" <no************@planet.nlwrote in message
news:62**********************************@microsof t.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" <in**@nospam.infovis.co.ukschreef in bericht
news:O7**************@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


Jul 2 '08 #3
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]" <no************@planet.nlwrote in message
news:62**********************************@microsof t.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" <in**@nospam.infovis.co.ukschreef in bericht
news:O7**************@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



Jul 2 '08 #4
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

Jul 2 '08 #5
Cor Ligthert(MVP),

Which software did you use to translate your thoughts into English?

MH

Jul 3 '08 #6
As I had used software to translate, then it would have been much better.

However you probably speak only English and don't know that people who speak
more languages simple think in that language. That those thought don't come
always readable on paper, has nothing to do with translating,.

However with changing the text to many times.

But are one liners the only thing you can write?

Cor

"Backwater Geezer" <ge****@eu.conschreef in bericht
news:%2****************@TK2MSFTNGP02.phx.gbl...
Cor Ligthert(MVP),

Which software did you use to translate your thoughts into English?

MH

Jul 3 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: google | last post by:
I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems...
6
by: Nalaka | last post by:
Hi, I have a gridView (grid1), which as a templateColumn. In the template column, I have put in a gridView (grid2) and a ObjectDataSource (objectDataSource2). Question is... How to I pass the...
0
by: Henry | last post by:
Hi (how) Is it possible to link to another table, e.g using a dropdownlist with a lookup in another table than the one the datasource selects (updtes/inserts) to/from? I have two tables where...
5
by: NickCR_04 | last post by:
Hi all, I am (using ASP.net 2.0 in Visual Web developer 2005 Express Edit) trying to set up an asp front end to a music DB which has 2 main tables: 1) MUSIC - containing music release...
0
by: dwight | last post by:
I am using the VS2005 xsd generator to create an access layer. I am having trouble figuring out how to add lookup fields to a gridview when binding with an object data source Say I have a table...
1
geo039
by: geo039 | last post by:
I have a user control that uses a lookup table to populate. When the user clicks the loopup icon for building, a list of items they can choose from appears. How could I populate the same control...
2
by: Thammarat charoenchai. | last post by:
Hi. I'm newbie to asp.net now i can use gridview to show data from sqldatasource. But I wonder How to show lookup field data. like get parameter from querystring name "pid" (ProductID)...
3
by: Ken Fine | last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets and DataTables should be able to answer fairly easily. The basic question is how I can efficiently match data from one...
3
by: Peter | last post by:
I have a GridView which is populated by List<ofObjects> Does anyone have example of how to sort the columns of this GridView? I have found examples without DataSourceControl but these use...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.