4,818
社区成员
发帖
与我相关
我的任务
分享
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");
CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["WO_Users"]);
CrystalReportSource1.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();
conn.Close();
}
}
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;
}
}