Question

datatable排序，为什么显示无法找到列 ID

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=paixu;Integrated Security=True");
string str ="select * from tb_User";
SqlDataAdapter da = new SqlDataAdapter(str,conn);
DataTable dt = new DataTable();
DataView dv = dt.DefaultView;
dv.Sort = "ID Asc,i_name Desc";
dt = dv.ToTable();

rpt.DataSource = dt;
rpt.DataBind();

数据库列名分别为 ID i_name
然后为什么这么写就出错了？

Answer 1

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=paixu;Integrated Security=True");
        string str ="select * from tb_User";
        SqlDataAdapter da = new SqlDataAdapter(str,conn);
        
        DataSet ds = new DataSet();
        da.Fill(ds, "ds");
        
        DataTable dt = ds.Tables[0];
        DataView dv = dt.DefaultView;
        dv.Sort = "ID Asc,i_name Desc";
        dt = dv.ToTable();

        rpt.DataSource = dt;
        rpt.DataBind();

Answer 2

缺少填充到表 da.Fill(dt);因为数据表没数据