我配置好了一个水晶报表 可是页面上什么都不显示 这是为啥啊 希望高手帮忙谢谢!!!
下面是代码:public partial class ContentPage_Memory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
bindCystall();
}
private void bindCystall()
{
string Sql_str = "select * from WO_Users";
string connstr = GetMsSqlConnStr();
DataSet ds = new DataSet();
using (OleDbConnection conn = new OleDbConnection(GetMsSqlConnStr()))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter ada = new OleDbDataAdapter();
cmd.CommandText = Sql_str;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn; ada.SelectCommand = cmd;
ada.Fill(ds, "WO_Users");
conn.Close(); CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["WO_Users"]);
CrystalReportSource1.DataBind(); CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
} }
public static string GetMsSqlConnStr()
{
string str = "Provider=Microsoft.Jet.OleDb.4.0;";
str += "Data Source=" + HttpContext.Current.Server.MapPath("~/app_data\\WoNext.mdb") + ";";
str += " User ID=" + System.Configuration.ConfigurationManager.AppSettings["databaseuserid"] + ";";
str += "Jet OLEDB:Database Password=" + System.Configuration.ConfigurationManager.AppSettings["databasepassword"] + ";";
return str;
}
}下面是页面显示:
下面是代码:public partial class ContentPage_Memory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
bindCystall();
}
private void bindCystall()
{
string Sql_str = "select * from WO_Users";
string connstr = GetMsSqlConnStr();
DataSet ds = new DataSet();
using (OleDbConnection conn = new OleDbConnection(GetMsSqlConnStr()))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter ada = new OleDbDataAdapter();
cmd.CommandText = Sql_str;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn; ada.SelectCommand = cmd;
ada.Fill(ds, "WO_Users");
conn.Close(); CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["WO_Users"]);
CrystalReportSource1.DataBind(); CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
} }
public static string GetMsSqlConnStr()
{
string str = "Provider=Microsoft.Jet.OleDb.4.0;";
str += "Data Source=" + HttpContext.Current.Server.MapPath("~/app_data\\WoNext.mdb") + ";";
str += " User ID=" + System.Configuration.ConfigurationManager.AppSettings["databaseuserid"] + ";";
str += "Jet OLEDB:Database Password=" + System.Configuration.ConfigurationManager.AppSettings["databasepassword"] + ";";
return str;
}
}下面是页面显示:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货