public DataSet RetornaClientesByName(string nome)
{
using (ConexaoBD conexao = new ConexaoBD())
{
DataSet ds = new DataSet();
SqlDataAdapter da;
da = new SqlDataAdapter($"select * from tb_cliente where nome like '%{nome}%'", conexao.ConectarBD());
da.Fill(ds);
conexao.DesconectarBD();
return(ds);
}
}
public DataSet RetornaClientes()
{
using (ConexaoBD conexao = new ConexaoBD())
{
DataSet ds = new DataSet();
SqlDataAdapter da;
da = new SqlDataAdapter("select * from tb_cliente", conexao.ConectarBD());
da.Fill(ds);
conexao.DesconectarBD();
return(ds);
}
}
