4,816
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
string sqlselectCountry = "select distinct Country from Customer";
OleDbDataAdapter daCountry = new OleDbDataAdapter(sqlselectCountry, cn);
DataSet dset = new DataSet();
daCountry.Fill(dset, "sCountry");
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
ParameterRangeValue rangeVal = new ParameterRangeValue();
// 设置参数字段的名称,它必须
//和报表中的参数相符。
paramField.ParameterFieldName = "selectCountry";
// 设置第离散值并将其传递给该参数。
foreach (DataRow item in dset.Tables["sCountry"].Rows)
{
discreteVal = new ParameterDiscreteValue();
discreteVal.Value = item[0].ToString();
paramField.CurrentValues.Add(discreteVal);
}
// 将该参数添加到参数字段集合。
paramFields.Add(paramField);
// 将参数字段集合放入查看器控件。
this.CrystalReportViewer1.ParameterFieldInfo = paramFields;
string sqlselectCountry = "select distinct Country from Customer";
OleDbDataAdapter daCountry = new OleDbDataAdapter(sqlselectCountry, cn);
DataSet dset = new DataSet();
daCountry.Fill(dset, "sCountry");
ParameterDiscreteValue pv;
ParameterValues pvs = new ParameterValues();
pv = new ParameterDiscreteValue();
foreach (DataRow item in dset.Tables["sCountry"].Rows)
{
pv.Value = item[0].ToString();
pvs.Add(pv);
}
myReport.SetParameterValue("selectCountry", pvs);