Proprietà DataGridView.DataSource (System.Windows.Forms)

Private Sub InitializeDataGridView()
    Try
        ' Set up the DataGridView.
        With Me.dataGridView1
            ' Automatically generate the DataGridView columns.
            .AutoGenerateColumns = True

            ' Set up the data source.
            bindingSource1.DataSource = GetData("Select * From Products")
            .DataSource = bindingSource1

            ' Automatically resize the visible rows.
            .AutoSizeRowsMode = _
                DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders

            ' Set the DataGridView control's border.
            .BorderStyle = BorderStyle.Fixed3D

            ' Put the cells in edit mode when user enters them.
            .EditMode = DataGridViewEditMode.EditOnEnter
        End With
    Catch ex As SqlException
        MessageBox.Show("To run this sample replace " _
            & "connection.ConnectionString with a valid connection string" _
            & "  to a Northwind database accessible to your system.", _
            "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
        System.Threading.Thread.CurrentThread.Abort()
    End Try
End Sub

Private Shared Function GetData(ByVal sqlCommand As String) _
    As DataTable

    Dim connectionString As String = _
        "Integrated Security=SSPI;Persist Security Info=False;" _
        & "Initial Catalog=Northwind;Data Source=localhost"

    Dim northwindConnection As SqlConnection = _
        New SqlConnection(connectionString)

    Dim command As New SqlCommand(sqlCommand, northwindConnection)
    Dim adapter As SqlDataAdapter = New SqlDataAdapter()
    adapter.SelectCommand = command

    Dim table As New DataTable
    table.Locale = System.Globalization.CultureInfo.InvariantCulture
    adapter.Fill(table)

    Return table

End Function

private void InitializeDataGridView()
{
    try
    {
        // Set up the DataGridView.
        dataGridView1.Dock = DockStyle.Fill;

        // Automatically generate the DataGridView columns.
        dataGridView1.AutoGenerateColumns = true;

        // Set up the data source.
        bindingSource1.DataSource = GetData("Select * From Products");
        dataGridView1.DataSource = bindingSource1;

        // Automatically resize the visible rows.
        dataGridView1.AutoSizeRowsMode =
            DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;

        // Set the DataGridView control's border.
        dataGridView1.BorderStyle = BorderStyle.Fixed3D;

        // Put the cells in edit mode when user enters them.
        dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;
    }
    catch (SqlException)
    {
        MessageBox.Show("To run this sample replace connection.ConnectionString" +
            " with a valid connection string to a Northwind" +
            " database accessible to your system.", "ERROR",
            MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
        System.Threading.Thread.CurrentThread.Abort();
    }
}

private static DataTable GetData(string sqlCommand)
{
    string connectionString = "Integrated Security=SSPI;" +
        "Persist Security Info=False;" +
        "Initial Catalog=Northwind;Data Source=localhost";

    SqlConnection northwindConnection = new SqlConnection(connectionString);

    SqlCommand command = new SqlCommand(sqlCommand, northwindConnection);
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = command;

    DataTable table = new DataTable();
    table.Locale = System.Globalization.CultureInfo.InvariantCulture;
    adapter.Fill(table);

    return table;
}

void InitializeDataGridView()
{
   try
   {
      // Set up the DataGridView.
      dataGridView1->Dock = DockStyle::Fill;

      // Automatically generate the DataGridView columns.
      dataGridView1->AutoGenerateColumns = true;

      // Set up the data source.
      bindingSource1->DataSource = GetData( "Select * From Products" );
      dataGridView1->DataSource = bindingSource1;

      // Automatically resize the visible rows.
      dataGridView1->AutoSizeRowsMode = DataGridViewAutoSizeRowsMode::DisplayedCellsExceptHeaders;

      // Set the DataGridView control's border.
      dataGridView1->BorderStyle = BorderStyle::Fixed3D;

      // Put the cells in edit mode when user enters them.
      dataGridView1->EditMode = DataGridViewEditMode::EditOnEnter;
   }
   catch ( SqlException^ ) 
   {
      MessageBox::Show( "To run this sample replace connection.ConnectionString"
      " with a valid connection string to a Northwind"
      " database accessible to your system.", "ERROR", MessageBoxButtons::OK, MessageBoxIcon::Exclamation );
      System::Threading::Thread::CurrentThread->Abort();
   }
   catch ( System::Exception^ ex ) 
   {
      MessageBox::Show( ex->ToString() );
   }
}


DataTable^ GetData( String^ sqlCommand )
{
   String^ connectionString = "Integrated Security=SSPI;Persist Security Info=False;"
   "Initial Catalog=Northwind;Data Source= localhost";
   SqlConnection^ northwindConnection = gcnew SqlConnection( connectionString );
   SqlCommand^ command = gcnew SqlCommand( sqlCommand,northwindConnection );
   SqlDataAdapter^ adapter = gcnew SqlDataAdapter;
   adapter->SelectCommand = command;
   DataTable^ table = gcnew DataTable;
   adapter->Fill( table );
   return table;
}