水晶报告中的参数化查询 [英] Parameterized query in crystal report

问题描述

我的代码工作正常..我在想他们的另一种方式参数化我的查询？

请帮助..新手..



类似..

my code works fine.. i was thinking if theirs another way to parameterized my query?
please help.. newbie..

something like..

string query = "Select * from tblresident where gender=@1";

我的尝试：

What I have tried:

SqlConnection cnn = new SqlConnection(cs.constring());
cnn.Open();
string query = "Select * from tblresident where gender='"+textBox1.Text+"'";
SqlDataAdapter da = new SqlDataAdapter(query, cnn);
DataSet ds = new DataSet();
da.Fill(ds, "tblresident");
rpt.Load(System.Windows.Forms.Application.StartupPath + "\\reports\\CrystalReport1.rpt");
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;

推荐答案

是

Yes

SqlConnection cnn = new SqlConnection(cs.constring());
cnn.Open();
string query = "Select * from tblresident where gender=@gender";
SqlCommand cmd = new SqlCommand(query, cnn);
cmd.Parameters.AddWithValue("@gender", textBox1.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "tblresident");

这篇关于水晶报告中的参数化查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！