I have one main table which references several other lookup tables, like
think of on the main table for example a category_id column with a categories
table which maps that id to a string value.
I used the .NET IDE to make my dataGrid and all those data adapters and so
on and it works great with update too, if I add a row and call
adapter.Update() it works fine. But right now I am only selected from the
main table so it's showing all these ID fields which I dont want shown, I
want to see the string value those ids are mapped to in other tables, so i
need some joins in the SQL.
How do I do this?
One thing I tried was going into the dataset designer page where it shows me
my datasources and I clicked configure on my main table, and I editted it's
query so that i does a join with the sub tables. This worked for loading the
DataGrid but all of a sudden the Update method on my adapter disappeared! So
I was no longer able to add data!
What happened and what is the right way to do this so that I can still
insert data into my main table