How To Add, Delete And Update Database Using Datagridview vb.net 2010

See more:

SQL-Server-2005

VB

SQL-Server

, +

Hello
i am making some application using vb.net 2010 and sql server 2005, i have 12 columns in my table "Beini" and have datagridview1. usign the following code i can populate all data stored in sql database to datagridview1.

Dim cmd As SqlCommand = New SqlCommand("Select * FROM Beini", conn)
        conn.Open()
        Dim myDA As SqlDataAdapter = New SqlDataAdapter(cmd)
        Dim myDataSet As DataSet = New DataSet()
        myDA.Fill(myDataSet, "Beini")
        DataGridView1.DataSource = myDataSet.Tables("Beini").DesignMode
        conn.close

my problem is i didn't know how to Add, Delete And Update Database from Datagridview1

thank you
i hope you will help me