Datasource with join and table adapter..
I am wanting to show 5 columns from one table, and one column from another, that joins using the same unique ID column (basically a description of the value in question).
However, when I set up this query in my datasources, it will not automatically write out updates or inserts for my table adapter...
Do I basically have to write these myself as well, since the data I want to update is from the 5 column table, and not the table I am joining just to get a description?
Thanks for any suggestions,
[526 byte] By [
bjswift] at [2007-11-20 10:25:32]
# 1 Re: Datasource with join and table adapter..
Yes you do have to write them yourself. If your query involves two tables then how is the wizard to know which one it should update? It can't know, so it doesn't try. It leaves it up to you.
Select your TableAdapter in the DataSet designer, open the Properties window and then select the command you want to create. Select New from the drop-down list then expand the node and enter the CommandText, which you can do either manually or using the wizard.
# 2 Re: Datasource with join and table adapter..
Geesh, isn't there a silver bullet? </scarcastic>
Ok, makes sense. Threw me for a loop, and ended up not using the design time components to get the job done, and worked around it. Next time, I will know better, and just write out the statements I would need to write normally anyhow.
Thanks for the reply!
# 3 Re: Datasource with join and table adapter..
You don't have to write out the statements at all. You can still use the Query Designer to create the statements visually, as I said in my previous post. It's important to realise that if you had simply read the documentation on TableAdapters in the MSDN library you'd have found out what to do. How do you suppose I know? Reading the documentation seems to be the last choice when help is required for a great many people, not just yourself, but I suggest you make it your first choice very quickly if you intend to become any sort of developer.
