public bool existeDocumento(int doc)
        {
            bool          bandera = false;
            SqlDataReader dr;

            cmd             = new SqlCommand("SP_EXISTE_DNI_AFILIADO", Conectar.ObtenerConexion());
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@NRODOC", SqlDbType.Int).Value = doc;
            dr = cmd.ExecuteReader();
            Conectar.CerrarConexion();

            if (dr.Read())
            {
                bandera = true;
            }

            return(bandera);
        }
예제 #2
0
        public void cargarDataGrid(DataGridView miDataGrid, string consulta)
        {
            DataSet        miDataSet = new DataSet();
            SqlDataAdapter da        = new SqlDataAdapter(consulta, Conectar.ObtenerConexion());

            da.Fill(miDataSet);
            Conectar.CerrarConexion();
            miDataGrid.RowHeadersVisible        = false;
            miDataGrid.AllowUserToAddRows       = false;
            miDataGrid.AllowUserToDeleteRows    = false;
            miDataGrid.AllowUserToOrderColumns  = false;
            miDataGrid.AllowUserToResizeColumns = true;
            miDataGrid.AllowUserToResizeRows    = false;
            miDataGrid.AutoResizeColumns();
            miDataGrid.DataSource = miDataSet.Tables[0];
            //estas dos lineas siguientes indican q las celdas se ajusten al contenido
            //-----------------------------------------------------------------------
            miDataGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
            miDataGrid.BorderStyle         = BorderStyle.None;
            //---------------------------------------------------------------------
        }