Question

无法将类型为“System.Windows.Forms.BindingSource”的对象强制转换为类型“System.Data.DataTable"？

SqlDataAdapter adapter;
public DataTable dbconn(string strsql) { adapter = new SqlDataAdapter(strsql, conn); DataTable stselect = new DataTable(); int rnt = adapter.Fill(stselect); return stselect; } int intindex = 0; public Boolean dbupdate(DataGridView dgv) { DataTable dtupdate = new DataTable(); dtupdate = this.dbconn("select* from Reports"); dtupdate.Rows.Clear(); DataTable dtshow = new DataTable(); dtshow = (DataTable)dgv.DataSource; dtupdate.ImportRow(dtshow.Rows[intindex]);

Answer 1

dtshow = (DataTable)dgv.DataSource改成dtshow = (DataTable)dgv.DataSource.DefaultView;
DefaultView 属性:获取可能包括筛选视图或游标位置的表的自定义视图。