I have two tables in my datasource, feeder type and feederserialnumbers

I need to show fields from both tables in my datagridview then beable to update one of the tables.

SELECT FeederSerialNumbers.SerialNumber, FeederSerialNumbers.Site, [Feeder Type].[feeder cost], [Feeder Type].[feeder type], FeederSerialNumbers.status,
FeederSerialNumbers.ActiveDate
FROM [Feeder Type] INNER JOIN
FeederSerialNumbers ON [Feeder Type].[Type Id] = FeederSerialNumbers.TypeId

when the user clicks a save button I wanted to update any changes to the datagridview

Hi Ljhopkins,

The DataSet designer can only generate the InsertCommand, UpdateCommand and DeleteCommand from SelectCommand which returns items from more than one table. To enable the auto-generation, the SelectCommand must have the following feature.

· Returns items from single-table

· Returns at least one primary key or unique column

In your case, your SelectCommand returns item from two tables, you need to create the InsertCommand, UpdateCommand and DeleteCommand yourself to make the DbDataAdapter to work.

More information, please check:

· http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand.aspx

· http://support.microsoft.com/kb/308507

Hope this helps.
Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

Hi Ljhopkins,

The DataSet designer can only generate the InsertCommand, UpdateCommand and DeleteCommand from SelectCommand which returns items from more than one table. To enable the auto-generation, the SelectCommand must have the following feature.

· Returns items from single-table

· Returns at least one primary key or unique column

In your case, your SelectCommand returns item from two tables, you need to create the InsertCommand, UpdateCommand and DeleteCommand yourself to make the DbDataAdapter to work.

More information, please check:

· http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand.aspx

· http://support.microsoft.com/kb/308507

Hope this helps.
Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs