C# (CSharp) ConexaoBD.DesconectarBD示例

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

示例#2

显示文件

文件： ClienteDAO.cs 项目： gustavoferreira07/PIM_Desktop

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