Comments by Vista007 (Top 4 by date)

DataTable dt1 = sds.Tables[0];
dt1.Columns.Remove(dt1.Columns[2]);
dt1.AcceptChanges();
dataGridView1.DataSource = dt1;

hi, The above code removes the column which i want to remove from data grid. but simultaneously tha checkedlistbox populating the column 3 value is now showing "System.data.datasource " in all coulmn in checklist box?

how now?

As from code i am also populating some colum into listbox and checked list box. So SELECT * FROM MovieType is correct for that.
To populate only 2 coulmn form a table of 3 column. code below is not working.

this.dataGridView1.DataSource = sds.Tables[#Quote#MovieType#Quote#];
this.dataGridView1.DisplayMember = #Quote#Rating#Quote#,#Quote#TypeID#Quote#;

Please help. also Datagrid doesnt have property of DisplayMember .

Please help

I have tryed.. but not working.. can you give appropriate code.