Question

asp.net中的DataSet ds查询问题

{ DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.SqlConnection, CommandType.Text, "select USER_ID ,USER_NAME,CERTIFICATE_NO,ADDRESS,PERSONAL_INFO,EMAIL,PERIOD_FORE_UP_CUMUT,PERIOD_FORE_DOWN_CUMUT,PERIOD_NTD_FLOW_SUM_CUMUT from USERINFO where USER_NAME='" + tbx_xuehao.Text + "'"); this.GridView1.DataSource = ds.Tables[0].DefaultView; this.GridView1.DataBind(); }aspx.cs中的代码是这样的。执行后查出数据是【图1】现在想要将效果变为【图2】查阅了各种资料也不知道该如何去做？谢谢。





Answer 1

DataTable dt = ds.Tables[0];
dt.Columns["USER_ID"].ColumnName = "用户";
dt.Columns["USER_NAME"].ColumnName = "名字";
this.GridView1.DataSource = dt;
this.GridView1.DataBind();