如何使用水晶报告显示1位用户进行打印 [英] How can I use crystal report to show 1 user to print

问题描述

你好

i希望在我的数据网格视图上打印1条记录到水晶报告，但我不知道该怎么做我尝试了一些方法，但我只需打印所有数据< br $> b $ b

我尝试了什么：



所以这是我的代码crystal report

  private   void  Print_Click（ object  sender，EventArgs e）
 {
 
 Print print =  new  Print（）; 
 print.ShowDialog（）; 
  if （conect.State！= ConnectionState.Open）
 {
 conect.Open（）; 
} 
  string  cs =  从Sign_Up中选择* ; 
 OleDbCommand command =  new  OleDbCommand（cs，conect）; 
 OleDbDataAdapter adap =  new  OleDbDataAdapter（command）; 
 DataSet dt =  new  DataSet（）; 
 adap.Fill（dt，  Sign_Up）; 
 CrystalReport1 crs1 =  new  CrystalReport1（）; 
 crs1.SetDataSource（dt）; 
 print.crystalReportViewer1.ReportSource = crs1; 
 conect.Close（）; 
 print.crystalReportViewer1.Refresh（）; 
 

它打印数据网格视图中的所有数据但我想打印我选择的用户

i我正在使用访问数据基地

任何人都有建议吗？

谢谢

解决方案

将此行更改为自定义您的查询;目前，它选择全部（*）

 string cs =select * from Sign_Up; 

< blockquote>我将行更改为此但它没有显示任何内容

  string  cs =  从Sign_Up中选择[ID]，[UserName]，[Item_Name]，[Price]; ; 

hello
i want to print 1 record on my data gird view to the crystal report but i don't know how to do that i tried some methods but i only got to print all the data

What I have tried:

so this is my code to the crystal report

private void Print_Click(object sender, EventArgs e)
       {

           Print print = new Print();
           print.ShowDialog();
           if (conect.State!=ConnectionState.Open)
           {
               conect.Open();
           }
           string cs = "select * from Sign_Up";
           OleDbCommand command = new OleDbCommand(cs,conect);
           OleDbDataAdapter adap = new OleDbDataAdapter(command);
           DataSet dt = new DataSet();
           adap.Fill(dt, "Sign_Up");
           CrystalReport1 crs1 = new CrystalReport1();
           crs1.SetDataSource(dt);
           print.crystalReportViewer1.ReportSource = crs1;
           conect.Close();
           print.crystalReportViewer1.Refresh();

it print all the data in the data grid view but i want to print the user i chose
i am useing access data base
any one have suggestions ?
thanks

解决方案

Change this line to "customize" your query; currently, it's selecting "all" (*)

string cs = "select * from Sign_Up";

I changed the line to this but it did not show anything

string cs = "select [ID],[UserName],[Item_Name],[Price] from Sign_Up";

这篇关于如何使用水晶报告显示1位用户进行打印的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！