private void Bindgridview()
{
String strConnection = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; SqlConnection myConnection = new SqlConnection(strConnection); SqlDataAdapter da = new SqlDataAdapter("select userLogName,username,sex,phone,mobilephone,businessstate,sysdate from business c join users u on c.userid=u.userid", myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "users");
DataView dv = ds.Tables[0].DefaultView;
if (ViewState["sortexpression"] != null)
{
dv.Sort = ViewState["sortexpression"].ToString() + " " + ViewState["sortdirection"].ToString();
} GridView1.DataSource = dv;
GridView1.DataBind(); //DataBinding:“System.Data.DataRowView”不包含名为“userID”的属性。
}
select userLogName,username,sex,phone,mobilephone,businessstate,sysdate from business c join users u on c.userid=u.userid
这个视图在查询分析器中是可以的啊
{
String strConnection = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; SqlConnection myConnection = new SqlConnection(strConnection); SqlDataAdapter da = new SqlDataAdapter("select userLogName,username,sex,phone,mobilephone,businessstate,sysdate from business c join users u on c.userid=u.userid", myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "users");
DataView dv = ds.Tables[0].DefaultView;
if (ViewState["sortexpression"] != null)
{
dv.Sort = ViewState["sortexpression"].ToString() + " " + ViewState["sortdirection"].ToString();
} GridView1.DataSource = dv;
GridView1.DataBind(); //DataBinding:“System.Data.DataRowView”不包含名为“userID”的属性。
}
select userLogName,username,sex,phone,mobilephone,businessstate,sysdate from business c join users u on c.userid=u.userid
这个视图在查询分析器中是可以的啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货