Linq to SQL - DataGridView

[Dan Tallent]

I'm having a problem making the leap from working with queries to connecting
them to a datagridview for use.


I have been able to setup a grid and set its bindingsource so it correctly
displays the data when I apply the query to the bindingsource using code
like:

this.MaterialBindingSource.DataSource = Mats;

where Mats is defined as IEnumerable < Material > and is populated by
executing a Linq Query against the SQL database.

This method even allows me to modify any of the data and update the SQL
database by using the SubmitChanges method of the DataContext.

The problem I'm having is I've been unable to figure out how to add new rows
using the grid or through code.

Any help filling in the gaps here will be most appreciated.

Thanks
Dan