Code Block
protected void btnGerarRelatorio_Click(object sender, EventArgs e)
{
string tipo = " " ;
if( rdbResolve.Checked )
tipo = "RESOLVE";
else if( rdbResponde.Checked )
tipo = "RESPONDE";
string sql = "SELECT ger.Gerente AS Gerente, ass.Assunto AS Assunto, COUNT(trans.TransacaoID) AS Qtde, trans.Data FROM Gerentes ger, Assuntos ass, Transacoes trans WHERE ger.GerenteId = trans.GerenteID AND ass.AssuntoId = trans.AssuntoID AND trans.Data BETWEEN @dataInicio AND @dataFim AND ass.Tipo = @tipo";
SqlConnection conn = new SqlConnection("Data Source=SRIRJO01023;Initial Catalog=Resolve;Persist Security Info=True;User ID=sa;Password=gecarrj");
SqlCommand cmd = new SqlCommand( sql , conn );
cmd.Parameters.AddWithValue("@dataInicio", Convert.ToDateTime(txtDataInicial.Text));
cmd.Parameters.AddWithValue("@dataFim", Convert.ToDateTime(txtDataFinal.Text));
cmd.Parameters.AddWithValue( "@tipo", tipo );
SqlDataAdapter da = new SqlDataAdapter( Convert.ToString(cmd) , Convert.ToString(conn) );
DataTable dt = new DataTable();
da.Fill( dt );
grvRelatorio.DataSource = dt;
grvRelatorio.DataBind();
}