Click here to Skip to main content
15,903,856 members
Home / Discussions / C#
   

C#

 
GeneralRe: TaskbarNotification display problems Pin
eynkram17-Feb-05 3:52
eynkram17-Feb-05 3:52 
GeneralProblem while Working with XmlValidatingReader!!!!! Pin
abcxyz8211-Feb-05 4:01
abcxyz8211-Feb-05 4:01 
GeneralRe: Problem while Working with XmlValidatingReader!!!!! Pin
Phil Hobgen11-Feb-05 22:53
Phil Hobgen11-Feb-05 22:53 
GeneralAppDomain and ResolveEventArgs Pin
Marc Clifton11-Feb-05 3:24
mvaMarc Clifton11-Feb-05 3:24 
GeneralRe: AppDomain and ResolveEventArgs Pin
Daniel Turini11-Feb-05 7:01
Daniel Turini11-Feb-05 7:01 
GeneralRe: AppDomain and ResolveEventArgs Pin
leppie11-Feb-05 9:45
leppie11-Feb-05 9:45 
Generalautomatic scroll down in rich text box Pin
kitsune_me11-Feb-05 2:57
kitsune_me11-Feb-05 2:57 
GeneralRe: automatic scroll down in rich text box Pin
leppie11-Feb-05 3:08
leppie11-Feb-05 3:08 
GeneralRe: automatic scroll down in rich text box Pin
kitsune_me11-Feb-05 18:27
kitsune_me11-Feb-05 18:27 
GeneralRe: automatic scroll down in rich text box Pin
mav.northwind11-Feb-05 4:36
mav.northwind11-Feb-05 4:36 
GeneralRe: automatic scroll down in rich text box Pin
kitsune_me11-Feb-05 5:25
kitsune_me11-Feb-05 5:25 
GeneralRe: automatic scroll down in rich text box Pin
mav.northwind11-Feb-05 6:07
mav.northwind11-Feb-05 6:07 
GeneralRe: automatic scroll down in rich text box Pin
Dave Kreskowiak11-Feb-05 9:13
mveDave Kreskowiak11-Feb-05 9:13 
GeneralRe: automatic scroll down in rich text box Pin
kitsune_me11-Feb-05 18:26
kitsune_me11-Feb-05 18:26 
GeneralRe: automatic scroll down in rich text box Pin
S. Senthil Kumar11-Feb-05 7:02
S. Senthil Kumar11-Feb-05 7:02 
GeneralRe: automatic scroll down in rich text box Pin
mav.northwind11-Feb-05 8:07
mav.northwind11-Feb-05 8:07 
GeneralRe: automatic scroll down in rich text box Pin
kitsune_me11-Feb-05 18:30
kitsune_me11-Feb-05 18:30 
GeneralRe: automatic scroll down in rich text box Pin
leppie11-Feb-05 9:50
leppie11-Feb-05 9:50 
Generalcosine rule Pin
Captain Trips11-Feb-05 1:38
Captain Trips11-Feb-05 1:38 
GeneralRe: cosine rule Pin
Stefan Troschuetz11-Feb-05 2:14
Stefan Troschuetz11-Feb-05 2:14 
GeneralRe: cosine rule Pin
Captain Trips11-Feb-05 3:21
Captain Trips11-Feb-05 3:21 
GeneralRe: cosine rule Pin
Stefan Troschuetz11-Feb-05 3:54
Stefan Troschuetz11-Feb-05 3:54 
GeneralSimple Database App - Combobox + DataGrid Pin
hollowMedia [0xFA7E]11-Feb-05 1:32
hollowMedia [0xFA7E]11-Feb-05 1:32 
I'm trying to find the best way to accomplish this; it seems what I'm doing is far too involved.

What I'd like to have is a combo box loaded with some IDs that is used to populate a datagrid that queries off of other tables (Access). The main problem I'm having is the DataSet/OleDbCommands I'm using apparently don't like having a multi-table query used. The data in the data grid is going to be a simple inner join off of a few tables, so names can be displayed as opposed to IDs.

To fix this, I set up a reader, then populated a queue and used that for the datagrid. This seems like a bit much effort, so I'd rather see if there's a better way.

Here's some pseudo-code for what I'm doing -
<br />
command = "select * from tab1, tab2 where id = @id"<br />
command.parameter = @id<br />
<br />
adapter = new adapter( command )<br />
apadter.fill( dataset )<br />
<br />
datagrid.datasource = dataset<br />
<br />
- event combochange -<br />
command.parameter.value = combo.selectedvalue<br />
adapter.fill( dataset )<br />


This code works well if there is only 1 table in use, but as soon as multiple tables are involved, it doesn't work so well. I've found ways to link multiple tables through relations, but I just need a read-only grid display of the data.

Any help is very much appreciated.

----
xian
GeneralRe: Simple Database App - Combobox + DataGrid Pin
hollowMedia [0xFA7E]15-Feb-05 1:05
hollowMedia [0xFA7E]15-Feb-05 1:05 
GeneralIIS Virtual Directories Enumeration Pin
Filipe Peixinho11-Feb-05 1:12
Filipe Peixinho11-Feb-05 1:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.