public DataTable ListarSucursal() { ConexionSQL cnn = new ConexionSQL(); SqlConnection cn = new SqlConnection(cnn.LeerConexionL()); SqlCommand cmd = new SqlCommand("usp_ReplicacionSucursalesSelect", cn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable tb = new DataTable(); da.Fill(tb); cn.Dispose(); cmd.Dispose(); return (tb); }