Click here to Skip to main content
15,898,987 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionWhat makes a control a container? Pin
John Hind27-May-05 2:42
John Hind27-May-05 2:42 
AnswerRe: What makes a control a container? Pin
Carl Mercier27-May-05 5:37
Carl Mercier27-May-05 5:37 
GeneralRe: What makes a control a container? Pin
Anonymous27-May-05 6:47
Anonymous27-May-05 6:47 
GeneralGarbage Collection Pin
Servietsky26-May-05 19:01
Servietsky26-May-05 19:01 
GeneralRe: Garbage Collection Pin
S. Senthil Kumar26-May-05 20:30
S. Senthil Kumar26-May-05 20:30 
GeneralWebservices for database - opinion Pin
Kaushik DIA26-May-05 8:15
Kaushik DIA26-May-05 8:15 
QuestionHow to programmatically apply some policy to user/group? Pin
mmsspp25-May-05 20:13
mmsspp25-May-05 20:13 
GeneralDataAdapter and muliple tables Pin
Luke Murray25-May-05 16:54
Luke Murray25-May-05 16:54 
Hey all. I am trying to set up a data adapter to show me a list of class. I do this with a select command that inner joins on some other tables to get some names etc. Then double clicking on an item brings up a dialog to edit that data.

The issue i'm having I guess is a design one. because I have all the data in the dataset on the form with the list should I use that to do the binding and editing in the popup dialog. This way I save a trip to the DB to get data I already have? If so, I then have to problem of I can't run DataAdapter.Update because the select command had inner join it did not generate update command or inserts.

So I can have two dataAdpaters each selecting their own table. Then when I update after the dialog closes. it will work. But then on the list I don't get the names showing as I havn't joined the tables in the select.

Is there a way to create a Expression column in one table (that is bound to th elist) that gets the correct name from the second table? The dataset has the relations set up in the xsd already.

Cheers, Hope that makes some sense.

Thanks

Luke
GeneralRe: DataAdapter and muliple tables Pin
Robert Rohde28-May-05 4:57
Robert Rohde28-May-05 4:57 
GeneralArray handling Pin
sarabjs25-May-05 9:58
sarabjs25-May-05 9:58 
GeneralRe: Array handling Pin
Scott Page25-May-05 15:26
professionalScott Page25-May-05 15:26 
GeneralRe: Array handling Pin
sarabjs26-May-05 6:04
sarabjs26-May-05 6:04 
GeneralRe: Array handling Pin
sarabjs26-May-05 11:32
sarabjs26-May-05 11:32 
GeneralRe: Array handling Pin
Scott Page27-May-05 4:06
professionalScott Page27-May-05 4:06 
GeneralRe: Array handling Pin
DavidNohejl26-May-05 12:02
DavidNohejl26-May-05 12:02 
GeneralRe: Array handling Pin
sarabjs27-May-05 8:44
sarabjs27-May-05 8:44 
GeneralRe: Array handling Pin
DavidNohejl28-May-05 6:32
DavidNohejl28-May-05 6:32 
GeneralRe: Array handling Pin
sarabjs30-May-05 7:54
sarabjs30-May-05 7:54 
GeneralRe: Array handling Pin
Robert Rohde27-May-05 5:41
Robert Rohde27-May-05 5:41 
GeneralRe: Array handling Pin
sarabjs27-May-05 9:26
sarabjs27-May-05 9:26 
GeneralRe: Array handling Pin
sarabjs27-May-05 9:48
sarabjs27-May-05 9:48 
GeneralRe: Array handling Pin
Robert Rohde28-May-05 0:40
Robert Rohde28-May-05 0:40 
GeneralRe: Array handling Pin
sarabjs30-May-05 7:44
sarabjs30-May-05 7:44 
GeneralRe: Array handling Pin
Robert Rohde30-May-05 8:31
Robert Rohde30-May-05 8:31 
GeneralRe: Array handling Pin
sarabjs30-May-05 10:18
sarabjs30-May-05 10:18 

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.