Datagridview

  //CLASS view1 is join TB_Student and TB_Depart

Private Const SELECT_STRING As String = _
"SELECT * FROM view1"

  //The DataSet that holds the data

   Private m_DataSet As DataSet
   Dim data_adapter As SqlDataAdapter

  //Create the SqlDataAdapter.

   data_adapter = New SqlDataAdapter(SELECT_STRING, _
       CONNECT_STRING)

  //Map Table to Contacts.

   data_adapter.TableMappings.Add("Table", "Contacts")

  // Fill the DataSet.

   m_DataSet = New DataSet()
   data_adapter.Fill(m_DataSet)

  //Bind the DataGrid control to the Contacts DataTable.

   dgContacts.SetDataBinding(m_DataSet,"view1")

If m_DataSet.HasChanges() Then
       Dim data_adapter As SqlDataAdapter
       Dim command_builder As SqlCommandBuilder

       // Create the DataAdapter.
       data_adapter = New SqlDataAdapter(SELECT_STRING, _
           CONNECT_STRING)

       // Map Table to Contacts.
       data_adapter.TableMappings.Add("Table", "view1")

       // Make the CommandBuilder generate the
       // insert, update, and delete commands.

       command_builder = New _
           SqlCommandBuilder(data_adapter)

       //Uncomment this code to see the INSERT,
       //UPDATE, and DELETE commands.
       //Debug.WriteLine("*** INSERT ***")
       //Debug.WriteLine(command_builder.GetInsertCommand.CommandText)
       //Debug.WriteLine("*** UPDATE ***")
       //Debug.WriteLine(command_builder.GetUpdateCommand.CommandText)
       //Debug.WriteLine("*** DELETE ***")
       //Debug.WriteLine(command_builder.GetDeleteCommand.CommandText)

       //Save the changes.
       data_adapter.Update(m_DataSet)

   End If