yanni2
دوشنبه 09 شهریور 1394, 19:46 عصر
با سلام من با این کد زیر در کریستال ریپورت جستجو میکنم ولی وقتی یک پارامتر وارد میکنم این پیغام را میدهد :
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
conn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + @"\DB\amlak2.mdf;Integrated Security=True;User Instance=True";
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Search7";
SqlParameter molahezat = new SqlParameter("@molahezat", textBox1.Text);
cmd.Parameters.Add(molahezat);
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = cmd;
DataSet ds = new DataSet();
dataadapter.Fill(ds);
ConnectionInfo connectionInfo = new ConnectionInfo();
ReportDocument RepDoc = new ReportDocument();
connectionInfo.ServerName = @".\SQLEXPRESS";
connectionInfo.DatabaseName = "amlak2";
string RepPath = Application.StartupPath + @"\CrystalReport1.rpt";
RepDoc.Load(RepPath);
RepDoc.SetDataSource(ds);
crystalReportViewer1.ReportSource = RepDoc;
// be ezay ferestadan yek parameter kar mikonan
ParameterValues parameterValues = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
parameterDiscreteValue.Value = textBox1.Text;
parameterValues.Add(parameterDiscreteValue);
ParameterFieldDefinitions parameterFieldDefinitions =
RepDoc.DataDefinition.ParameterFields;
ParameterFieldDefinition parameterFieldDefinition =
parameterFieldDefinitions["@molahezat"];
parameterFieldDefinition.ApplyCurrentValues(parame terValues);
}
}
پیغام خطا :
134797
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
conn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + @"\DB\amlak2.mdf;Integrated Security=True;User Instance=True";
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Search7";
SqlParameter molahezat = new SqlParameter("@molahezat", textBox1.Text);
cmd.Parameters.Add(molahezat);
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = cmd;
DataSet ds = new DataSet();
dataadapter.Fill(ds);
ConnectionInfo connectionInfo = new ConnectionInfo();
ReportDocument RepDoc = new ReportDocument();
connectionInfo.ServerName = @".\SQLEXPRESS";
connectionInfo.DatabaseName = "amlak2";
string RepPath = Application.StartupPath + @"\CrystalReport1.rpt";
RepDoc.Load(RepPath);
RepDoc.SetDataSource(ds);
crystalReportViewer1.ReportSource = RepDoc;
// be ezay ferestadan yek parameter kar mikonan
ParameterValues parameterValues = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
parameterDiscreteValue.Value = textBox1.Text;
parameterValues.Add(parameterDiscreteValue);
ParameterFieldDefinitions parameterFieldDefinitions =
RepDoc.DataDefinition.ParameterFields;
ParameterFieldDefinition parameterFieldDefinition =
parameterFieldDefinitions["@molahezat"];
parameterFieldDefinition.ApplyCurrentValues(parame terValues);
}
}
پیغام خطا :
134797