2
I intend to list all the data registered in a given week, someone can help me?
I did something similar to the example below and it doesn’t work.
public List<View_Venda> Venda_Semanais()
{
List<View_Venda> lis = new List<View_Venda>();
SqlConnection conexao = new SqlConnection(caminho);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conexao;
cmd.CommandType = CommandType.Text;
string lista = "select *from view_venda where data_registo=@data_registo <= DateTime.Now Add Day(-7) And DateTime.Today";
cmd.CommandText = lista;
cmd.Parameters.AddWithValue("@data_registo", DateTime.Today);
conexao.Close();
SqlDataReader dr;
conexao.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
View_Venda obj = new View_Venda();
obj.id_venda = Convert.ToInt32(dr["id_venda"].ToString());
obj.funcionario = dr["funcionario"].ToString();
obj.fundo_inicial = Convert.ToDecimal(dr["fundo_inicial"].ToString());
obj.total_veda_caixa = Convert.ToDecimal(dr["total_veda_caixa"].ToString());
obj.total_venda_multicaixa = Convert.ToDecimal(dr["total_venda_multicaixa"].ToString());
obj.total_multipagamento = Convert.ToDecimal(dr["total_multipagamento"].ToString());
obj.caixa_final = Convert.ToDecimal(dr["caixa_final"].ToString());
obj.conciliacao = Convert.ToDecimal(dr["conciliacao"].ToString());
obj.data_registo = Convert.ToDateTime(dr["data_registo"].ToString());
lis.Add(obj);
}
return lis;
}
does not return anything or triggers exception at some point? You can format the code using the editor options. (=
– Aline
This way will also generate error
– António Mateta