C# DataGridView: How to map defined columns to DataTable columns ??

[frostbb]

Ok, stumped one more time, I'm trying to learn how to use a DataGridView in
place of the old DataGrid control.
QUESTION: How do I map the columns returned from a RunTime sql query to the
columns defined (defined columns collection) in a DataGridView??

i.e.
sql_query.displ ay_name = dataGridView1.d g1vc_display_na me
sql_query.name_ last = dataGridView1.n ame_last
sql_query.name_ first = dataGridView1.n ame_first
sql_query.name_ mi = dataGridView1.n ame_mi
sql_query. name_company = dataGridView1.n ame_company
sql_query. name_other = dataGridView1.n ame_other
sql_query. street1 = dataGridView1.s treet1
sql_query.city = dataGridView1.c ity
sql_query.statu s = dataGridView1.s tatus
sql_query.last_ updt_date = dataGridView1.l ast_updt_date

This was easy to do with the old DataGrid control by setting a table style
and mapping the table style columns to the DataTable columns. I don't see
any way to do that with the DataGridView.

I've defined the following
private System.Windows. Forms.DataGridV iew dataGridView1;

private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_display_na me;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_last_updt_ date;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_name_last;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_name_first ;
private System.Windows. Forms.DataGridV iewTextBoxColum n dgv1_name_mi;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_name_compa ny;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_name_other ;
private System.Windows. Forms.DataGridV iewTextBoxColum n dgv1_street1;
private System.Windows. Forms.DataGridV iewTextBoxColum n dgv1_city;
private System.Windows. Forms.DataGridV iewTextBoxColum n
dgv1_entity_sta tus;

In my code I submit the following query generates a DataTable within a
DataSet object.

private void cmdSearch_Click (object sender, EventArgs e)
{

SELECT
dir_id,
dbo.return_disp lay_name(NULL,N ULL,directory_i d,'LFM',1,1,0,N ULL) as
display_name,
name_last,
name_first,
name_mi,
name_company,
name_other,
street1,
city,
status,
last_updt_date
FROM
directory
WHERE
name_last = '" + this.txtLastNam e.Text.ToUpper( ).ToString() + "' AND
(status IS NULL OR status = 'AC')
ORDER BY
name_last,
name_first,
name_mi,
name_company,
last_updt_date DESC

// The results of the query above are returned into
oDs.Tables["SearchResu lts"];
// This query returns about 40 rows.

this.bindingSou rce1.DataSource = oDs.Tables["SearchResu lts"];

this.dataGridVi ew1.DataSource = null;
this.dataGridVi ew1.DataBinding s.Clear();
this.dataGridVi ew1.DataSource = this.bindingSou rce1;

}

With "dataGridView1. AutoGenerateCol umns = true" the query columns are
appended to the defined dataGridView1co lumns.
With "dataGridView1. AutoGenerateCol umns = false" only the blank defined
dataGridView1co lumns appear.

Any help getting this working would be greatly appreciated !!!