急！！！！！！！！！数据源的类型无效

Question

数据源的类型无效。它必须是 IListSource、IEnumerable 或 IDataSourceString sql="select * from 员工信息表";
            SqlConnection con1=new SqlConnection("Data Source=PC-20130408LMVW;Initial Catalog=test;Integrated Security=True");
            SqlCommand cmd1=new SqlCommand(sql,con1);
            SqlDataAdapter ad1=new SqlDataAdapter(cmd1);
            DataTable dt1=new DataTable();
            con1.Open();
            ad1.Fill(dt1);
            GridView1.DataSource=ad1;
            GridView1.DataBind();
            con1.Close(); 

Answer 1

String sql="select * from 员工信息表";
            SqlConnection con1=new SqlConnection("Data Source=PC-20130408LMVW;Initial Catalog=test;Integrated Security=True");
            SqlCommand cmd1=new SqlCommand(sql,con1);
            SqlDataAdapter ad1=new SqlDataAdapter(cmd1);
            
         DataSet dset=new DataSet();
            con1.Open();
            ad1.Fill(dset);
            GridView1.DataSource=dset.Table[0];
            GridView1.DataBind();
            con1.Close(); 

Answer 2

楼上正解，DataSource应该是绑定DataTable，而你绑定成SqlDataAdapter 了

Answer 3

这一行，GridView1.DataSource=ad1;   要改成GridView1.DataSource=dt1; 绑定时要用datatable，也就是dt1,而不是ad1。

Answer 4

            String sql="select * from 员工信息表";
            SqlConnection con1=new SqlConnection("Data Source=PC-20130408LMVW;Initial Catalog=test;Integrated Security=True");
            SqlCommand cmd1=new SqlCommand(sql,con1);
            SqlDataAdapter ad1=new SqlDataAdapter(cmd1);
            DataTable dt1=new DataTable();
            con1.Open();
            ad1.Fill(dt1);
           GridView1.DataSource=ad1;
            GridView1.DataBind();
            con1.Close();