amin1000
شنبه 08 خرداد 1389, 08:35 صبح
سلام .میخوام جمع یک فیلدو در کریستال بدست بیارم ولی با ای کد انجام نمیشه !مشکلش کجاست؟
SqlConnection objconnection = new SqlConnection("server=localhost;database=a;user id=sa;password=");
SqlDataAdapter objdataadapter = new SqlDataAdapter("select sum(haghvisit) from paziresh", objconnection);
DataSet objdataset = new DataSet();
CrystalReport2 ortp = new CrystalReport2();
objconnection.Open();
objdataadapter.Fill(objdataset, "paziresh");
objconnection.Close();
ortp.SetDataSource(objdataset);
this.crystalReportViewer1.ReportSource = ortp;
SqlConnection objconnection = new SqlConnection("server=localhost;database=a;user id=sa;password=");
SqlDataAdapter objdataadapter = new SqlDataAdapter("select sum(haghvisit) from paziresh", objconnection);
DataSet objdataset = new DataSet();
CrystalReport2 ortp = new CrystalReport2();
objconnection.Open();
objdataadapter.Fill(objdataset, "paziresh");
objconnection.Close();
ortp.SetDataSource(objdataset);
this.crystalReportViewer1.ReportSource = ortp;