请教:gridview 显示不出 视图中数据???
我建了一个视图:
CREATE VIEW dbo.v_report_table
AS
SELECT u.true_name as 姓名,sum ( l.spent_time_normal) as 正常工作时间 ,sum(l.spent_time_overtime) as 加班时间,l.user_no as 登陆名 ,u.cost as 每小时费用
FROM logs l inner join user_info u on user_no=no group by u.cost, l.user_no, u.true_name
----------
我在gridview中显示代码:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class report : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection("server=127.0.0.1;uid=sa;pwd=wbok123;database=htpm");
SqlDataAdapter sda = new SqlDataAdapter("select * from v_report_table", conn);
conn.Open();
sda.Fill(ds, "v_report_table");
sda.Dispose();
conn.Close();
conn.Dispose();
this.dvReport.DataSource = ds.Tables["v_report_table"];
this.dvReport.DataBind();
}
}
----------
问题:运行后程序里,只显示了表头字段,没有显示数据.没有报错!