ado

[maryamf]

DA1 = new SqlDataAdapter("select * from tbmohasebe where tarikh = '"+comboBox1.Text +"'" , conn1); DA1.Fill(dt1); //dt1 is Data table dataGridView1.DataSource = dt1; how can i hide some of columns in datatable that don't show in datagrid?

[BoneSoft]

Use a specific select list... select field1, field2, field3 from Table where blah blah blah... Visit BoneSoft.com

[MoustafaS]

Isn't this working ?

dt1.Columns.Remove("columnName");

------------------------------
"The Soapbox has been so ..."

[albCode]

On load of your form or in any another event u can add code down below dataGridView1.Columns[index].Visible = false; //indexn is index of column which u want to hide in dataGridView