C#

create proc Cpost
@nopersoneli int
As
Select p.fname,p.lname,p.NoPersoneli,po.name from personal p
Join postpersonal pp
On p.NoPersoneli=pp.Cpersonal
Join post po
On po.code=pp.vpost

ReportDocument reportDocument = new ReportDocument();
           ParameterField paramField = new ParameterField();
           ParameterFields paramFields = new ParameterFields();
           ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
           paramField.Name = "@NoPersoneli";
           paramDiscreteValue.Value = "45";
           paramField.CurrentValues.Add(paramDiscreteValue);
           paramFields.Add(paramField);
           crystalReportViewer1.ParameterFieldInfo = paramFields;
           reportDocument.Load(@"C:\Documents and Settings\Administrator\Desktop\VEZARAT\VEZARAT\PostCrystalReport.rpt");
           reportDocument.SetDatabaseLogon("", "", "niloofar\\i2", "vezaratekar", false);
           crystalReportViewer1.ReportSource = reportDocument;