datagridview help required insert, update, delete

Question

Hi,

First time I am doing programming with datagridview. I read from net and various sites that it is very powerful to show data.

 

I have some question and want suggestion and tips or if possible some demo programming help.

 

1. Want grid should be for insert, update, delete with validation.
2. My data source is a mix table query means join of two or more table.
3. want columns as autocompletemode.
4. unique rows in grid some key values must be not in repeat