使用VS 2010的ASP.NET中的Crystal Reports [英] Crystal Reports in ASP.NET using VS 2010

问题描述

尊重所有人，

如何在.rpt文件中添加两个表，该文件具有主要的外键关系。



And在crystalReportViewer中显示特定值。



这是我的sql语句：

选择Material_Master.Material_Name，Purchase.Date，Purchase.Qty， Purchase.Each_Price，Purchase.Warehouse from Purchase，Material_Master，其中Purchase.Material_Code = Material_Master.Material_Code AND Sr_No =''+ TextBox1.Text +''



= =>问题是它不显示特定值，它显示所有值。



请给我一些指导..



谢谢.....

解决方案

查看此示例



< pre lang =c＃> private void button1_Click（ object sender，EventArgs e）
{
SqlConnec cnn;
string connectionString = null ;
string sql = null ;

connectionString = data source = SERVERNAME; initial catalog = DATABASENAME; user id = USERNAME;密码= PASSWORD;;
cnn = new SqlConnection（connectionString）;
cnn.Open（）;
sql = SELECT Product_id，Product_name，Product_price FROM Product;
SqlDataAdapter dscmd = new SqlDataAdapter（sql，cnn）;
DataSet1 ds = new DataSet1（）;
dscmd.Fill（ds， Product）;
MessageBox.Show（ds.Tables [ 1 ]。Rows.Count.ToString（））;
cnn.Close（）;

CrystalReport1 objRpt = new CrystalReport1（）;
objRpt.SetDataSource（ds.Tables [ 1 ]）;
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh（）;
}

Respected to all,
how to add two tables in .rpt file, which has primary n foreign key relation.

And display particular value in crystalReportViewer.

This is my sql statement:
"Select Material_Master.Material_Name,Purchase.Date,Purchase.Qty,Purchase.Each_Price,Purchase.Warehouse from Purchase,Material_Master where Purchase.Material_Code=Material_Master.Material_Code AND Sr_No=''"+TextBox1.Text+"''"

==>problem is that it dont display that particular values ,it display all values.

pls give me some guideline..

thanks.....

解决方案

check this example

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cnn ;
            string connectionString = null;
            string sql = null;

            connectionString = "data source=SERVERNAME;initial catalog=DATABASENAME;user id=USERNAME;password=PASSWORD;";
            cnn = new SqlConnection(connectionString);
            cnn.Open();
            sql = "SELECT Product_id,Product_name,Product_price FROM Product";
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet1 ds = new DataSet1();
            dscmd.Fill(ds, "Product");
            MessageBox.Show (ds.Tables[1].Rows.Count.ToString());
            cnn.Close();

            CrystalReport1 objRpt = new CrystalReport1();
            objRpt.SetDataSource(ds.Tables[1]);
            crystalReportViewer1.ReportSource = objRpt;
            crystalReportViewer1.Refresh();
        }

这篇关于使用VS 2010的ASP.NET中的Crystal Reports的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！