Ovo je kod koji imam ali on mi vraca prazan report :
Code:
private void button1_Click(object sender, EventArgs e)
{
if (proveraValidnosti() == false) return;
CrystalReport1 crp = new CrystalReport1();
string konekcija = Konekcija.SqlKonekcija;
SqlConnection conn = new SqlConnection(konekcija);
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
//ds.Tables.Add(dt);
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "dbo.DatumRacunaObrade";
comm.Parameters.Add("@MaticniBroj", SqlDbType.VarChar, 13);
comm.Parameters.Add("@DatumDospeca", SqlDbType.DateTime);
comm.CommandTimeout = 0;
comm.Parameters["@MaticniBroj"].Value = txtJMBG.Text.Trim();
comm.Parameters["@DatumDospeca"].Value = dtpGranDat.Value;
conn.Open();
da.SelectCommand = comm;
da.Fill(ds, "DatumRacunaObrade");
crp.SetDataSource(ds);
crystalReportViewer1.ReportSource = crp;
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (proveraValidnosti() == false) return;
CrystalReport1 crp = new CrystalReport1();
string konekcija = Konekcija.SqlKonekcija;
SqlConnection conn = new SqlConnection(konekcija);
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
//ds.Tables.Add(dt);
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "dbo.DatumRacunaObrade";
comm.Parameters.Add("@MaticniBroj", SqlDbType.VarChar, 13);
comm.Parameters.Add("@DatumDospeca", SqlDbType.DateTime);
comm.CommandTimeout = 0;
comm.Parameters["@MaticniBroj"].Value = txtJMBG.Text.Trim();
comm.Parameters["@DatumDospeca"].Value = dtpGranDat.Value;
conn.Open();
da.SelectCommand = comm;
da.Fill(ds, "DatumRacunaObrade");
crp.SetDataSource(ds);
crystalReportViewer1.ReportSource = crp;
conn.Close();
}
Pokusao sam preko wizarda ali ne sto nece ..
Moze li mi neko reci kako da radim?