Click here to Skip to main content
15,896,063 members
Home / Discussions / C#
   

C#

 
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 
GeneralCDO: Synchonize Exchange with Outlook Pin
swissglide11-Feb-05 0:17
swissglide11-Feb-05 0:17 
QuestionHow can I open Web page in Microsoft Web Browser through ATL Pin
devom11-Feb-05 0:06
devom11-Feb-05 0:06 
AnswerRe: How can I open Web page in Microsoft Web Browser through ATL Pin
Dave Kreskowiak11-Feb-05 4:17
mveDave Kreskowiak11-Feb-05 4:17 
GeneralCF memory leaks :-( :-( Pin
zuschauer198010-Feb-05 23:44
zuschauer198010-Feb-05 23:44 
GeneralRe: Serialize a String Pin
Nish Nishant10-Feb-05 22:12
sitebuilderNish Nishant10-Feb-05 22:12 
GeneralWSE Client Pin
qur10-Feb-05 21:13
qur10-Feb-05 21:13 
GeneralLose data on a TextBox Pin
sasan5610-Feb-05 20:48
sasan5610-Feb-05 20:48 
Generalget current row Pin
sasan5610-Feb-05 20:36
sasan5610-Feb-05 20:36 
GeneralKeyPress .... Pin
mitreviper10-Feb-05 20:36
mitreviper10-Feb-05 20:36 
GeneralRe: KeyPress .... Pin
Stefan Troschuetz10-Feb-05 21:14
Stefan Troschuetz10-Feb-05 21:14 
GeneralWin32_Process Pin
skrishnasarma10-Feb-05 17:08
skrishnasarma10-Feb-05 17:08 
GeneralRe: Win32_Process Pin
Dave Kreskowiak11-Feb-05 4:13
mveDave Kreskowiak11-Feb-05 4:13 
GeneralRe: Win32_Process Pin
skrishnasarma13-Feb-05 16:49
skrishnasarma13-Feb-05 16:49 
GeneralRe: Win32_Process Pin
Dave Kreskowiak13-Feb-05 17:08
mveDave Kreskowiak13-Feb-05 17:08 
GeneralRe: Win32_Process Pin
skrishnasarma13-Feb-05 17:29
skrishnasarma13-Feb-05 17:29 

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.