How to make a select that brings the data registered in a given week?

Question

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;
}

Answer 1

Have in your *Sqlcommand * Two parameters, one for the start date and one for the end date,(put in the example as A and B respectively), The string of the command was also incorrect, the dates you were trying to pass should be inserted in the parameters as below

string lista = "select * from view_venda where data_registo >= @data_registoA and  data_registo<=@data_registoB";
    cmd.CommandText = lista;
    cmd.Parameters.AddWithValue("@data_registoA", DateTime.Today.AddDays(-7));
    cmd.Parameters.AddWithValue("@data_registoB", DateTime.Today);