C# SqlDataReader.GetString方法代码示例

        /// <summary>
        /// Loads the entity from a <b>SqlDataReader</b> object.
        /// </summary>
        /// <param name="dr">The data reader to read from.</param>
        /// <returns>Returns the number of columns read.</returns>
        /// <remarks>
        /// Always reads at the current cursor position, doesn't calls the <b>Read</b> function
        /// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in
        /// the query and not by their names.
        /// </remarks>
        internal override int LoadFromDataReader(SqlDataReader dr)
        {
            int o = base.LoadFromDataReader(dr);

            ++o;    // skip guid
            this.workflowTypeName = dr.GetString(++o);
            this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
            this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
            this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o);
            this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
            this.scheduleType = (ScheduleType)dr.GetInt32(++o);
            this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
            this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o);
            this.recurringInterval = dr.GetInt32(++o);
            this.recurringMask = dr.GetInt64(++o);
            this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o);
            this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
            if (!dr.IsDBNull(++o))
            {
                XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData));
                StringReader sr = new StringReader(dr.GetString(o));
                this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr);
            }
            else
            {
                this.adminRequestData = null;
            }
            this.adminRequestResult = dr.GetInt32(++o);
            this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o);

            return o;
        }

        /// <summary>
        /// Creates a new instance of the ViewSeguridadUsuario class and populates it with data from the specified SqlDataReader.
        /// </summary>
        private static ViewSeguridadUsuarioInfo MakeViewSeguridadUsuario(SqlDataReader dataReader)
        {
            ViewSeguridadUsuarioInfo viewSeguridadUsuario = new ViewSeguridadUsuarioInfo();

            if (dataReader.IsDBNull(SeguridadUsuarioId) == false)
                viewSeguridadUsuario.SeguridadUsuarioId = dataReader.GetInt32(SeguridadUsuarioId);
            if (dataReader.IsDBNull(SeguridadRolId) == false)
                viewSeguridadUsuario.SeguridadRolId = dataReader.GetInt32(SeguridadRolId);
            if (dataReader.IsDBNull(Rol) == false)
                viewSeguridadUsuario.Rol = dataReader.GetString(Rol);
            if (dataReader.IsDBNull(NombreUsuario) == false)
                viewSeguridadUsuario.NombreUsuario = dataReader.GetString(NombreUsuario);
            if (dataReader.IsDBNull(Nombres) == false)
                viewSeguridadUsuario.Nombres = dataReader.GetString(Nombres);
            if (dataReader.IsDBNull(Apellidos) == false)
                viewSeguridadUsuario.Apellidos = dataReader.GetString(Apellidos);
            if (dataReader.IsDBNull(PaswordHash) == false)
                viewSeguridadUsuario.PaswordHash = dataReader.GetString(PaswordHash);
            if (dataReader.IsDBNull(Salt) == false)
                viewSeguridadUsuario.salt = dataReader.GetString(Salt);
            if (dataReader.IsDBNull(Activo) == false)
                viewSeguridadUsuario.Activo = dataReader.GetBoolean(Activo);
            if (dataReader.IsDBNull(NombreCompleto) == false)
                viewSeguridadUsuario.NombreCompleto = dataReader.GetString(NombreCompleto);

            return viewSeguridadUsuario;
        }

 protected void btnSignIn_Click(object sender, ImageClickEventArgs e)
 {
     if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "")
         lblMessage.Text = "Both fields are required";
     else
     {
         query = "select usertype from Login where username='" + txtUsername.Text + "' AND Password='" + txtPassword.Text + "'";
         reader = db.data_read(query);
         if (reader.Read())
         {
             if (reader.GetString(0).Trim() == "Employee") // Go to employee's home page
             {
                 Session["username"] = txtUsername.Text;
                 reader.Close();
                 Response.Redirect("~/employee/EmployeeHome.aspx");
             }
             else if (reader.GetString(0).Trim() == "Employer")// Go to employer's home page
             {
                 Session["username"] = txtUsername.Text;
                 reader.Close();
                 Response.Redirect("~/employer/EmployerHome.aspx");
             }
             else // Go to admin's home page
             {
                 Session["username"] = txtUsername.Text;
                 Response.Redirect("~/admin/Home.aspx");
             }
         }
         else
         {
             lblMessage.Text = "Invalid Username/Password or no such user exists";
         }
     }
 }

 private Documents(SqlDataReader data)
 {
     ID = data.GetInt32(0);
     Name = data.GetString(1);
     hash = data.GetString(2);
     buffer = data.GetSqlBinary(3).Value;
 }

        public static NewMemberBalancePrediction Factory(SqlDataReader reader)
        {
            var newMemberId = reader.GetInt32(0);
            var dependentId = reader.GetInt32(1);
            var birthYear = reader.GetInt32(2);
            var state = reader.GetString(3);
            var lastCptCode = reader.GetString(4);
            var cachedBalance = reader.GetString(5);
            var recommendedBalance = reader.GetValue(6);

            double d;
            double.TryParse(recommendedBalance == null ? "0" : recommendedBalance.ToString(), out d);
            var sufficientAmount = reader.GetInt32(7);
            var serviceEnd = reader.GetDateTime(8);

            return new NewMemberBalancePrediction
                       {
                           NewMemberId = newMemberId,
                                 DependentId = dependentId,
                                 BirthYear = birthYear,
                                 State = state,
                                 LastCptCode = lastCptCode,
                                 CachedBalance = cachedBalance,
                                 RecommendedBalance = Math.Round(d, 2),
                                 SufficientAmount = sufficientAmount,
                                 ServiceEnd = serviceEnd
                       };
        }

 public int getComments(int id, out List<string> name, out List<DateTime> date, out List<string> comments)
 {
     name = new List<string>();
     date = new List<DateTime>();
     comments = new List<string>();
     cmd.CommandText = "SELECT * FROM comment where id=" + id.ToString() + " ORDER BY comdate DESC";
     try
     {
         SqlInit();
         dr = cmd.ExecuteReader();
         while (dr.Read())
         {
             name.Add(dr.GetString(1));
             date.Add(dr.GetDateTime(2));
             comments.Add(dr.GetString(3));
         }
     }
     catch(SqlException e)
     {
         SqlExit();
         return 666;
     }
     if (name.Count == 0)
     {
         SqlExit();
         return 1;//no comments
     }
     SqlExit();
     return 0;//success
 }

        public static JArray SqlDataReader2Json(SqlDataReader reader, string col0, string col1)
        {
            var colNames = new Dictionary<string, int>();
            for (int i = 0; i < reader.FieldCount; i++)
            {
                colNames[reader.GetName(i)] = i;
            }

            var parent = new Dictionary<string, HashSet<string>>(StringComparer.OrdinalIgnoreCase);

            while (reader.Read())
            {
                string parentColumn = reader.GetString(colNames[col0]);
                string childColumn = reader.GetString(colNames[col1]);

                HashSet<string> child;
                if (!parent.TryGetValue(parentColumn, out child))
                {
                    child = new HashSet<string>(StringComparer.OrdinalIgnoreCase);
                    parent.Add(parentColumn, child);
                }

                child.Add(childColumn);
            }

            return MakeJArray(parent);
        }

        /// <summary>
        /// Creates a new instance of the ViewLDV class and populates it with data from the specified SqlDataReader.
        /// </summary>
        private static ViewLDVInfo MakeViewLDV(SqlDataReader dataReader)
        {
            ViewLDVInfo viewLDV = new ViewLDVInfo();

            if (dataReader.IsDBNull(Cod_LDV) == false)
                viewLDV.Cod_LDV = dataReader.GetInt32(Cod_LDV);
            if (dataReader.IsDBNull(Cod_TipoLDV) == false)
                viewLDV.Cod_TipoLDV = dataReader.GetInt32(Cod_TipoLDV);
            if (dataReader.IsDBNull(Tipo_LDV) == false)
                viewLDV.Tipo_LDV = dataReader.GetString(Tipo_LDV);
            if (dataReader.IsDBNull(Nombre_Lugar) == false)
                viewLDV.Nombre_Lugar = dataReader.GetString(Nombre_Lugar);
            if (dataReader.IsDBNull(Cod_Direccion) == false)
                viewLDV.Cod_Direccion = dataReader.GetInt32(Cod_Direccion);
            if (dataReader.IsDBNull(Calle) == false)
                viewLDV.Calle = dataReader.GetString(Calle);
            if (dataReader.IsDBNull(Cod_Localidad) == false)
                viewLDV.Cod_Localidad = dataReader.GetInt32(Cod_Localidad);
            if (dataReader.IsDBNull(Localidad) == false)
                viewLDV.Localidad = dataReader.GetString(Localidad);
            if (dataReader.IsDBNull(Cod_Provincia) == false)
                viewLDV.Cod_Provincia = dataReader.GetInt32(Cod_Provincia);
            if (dataReader.IsDBNull(Provincia) == false)
                viewLDV.Provincia = dataReader.GetString(Provincia);

            return viewLDV;
        }

        public Project(string name, string description, string businessvalue)
        {
            mName = name;
            mDescription = description;
            mBusinessValue = businessvalue;

            mDatabase.connect();

            mReader=mDatabase.executeread("SELECT Description FROM [dbo].[Issues] WHERE ProjectName='" + mName + "'");
            while (mReader.Read() )
            {
                mIssues.Add(new Issue(mReader.GetString(0).ToString(), mName));
            }
            mReader.Close();

            mReader = mDatabase.executeread("SELECT Description, Address FROM [dbo].[Link] WHERE ProjectName='" + mName + "'");
            while (mReader.Read() )
            {
                mLinks.Add(new Link(mReader.GetString(0).ToString(), mName, mReader.GetString(1).ToString()));
            }
            mReader.Close();

            mReader = mDatabase.executeread("SELECT DependantName, [dbo].[Project].Description, [dbo].[Project].BusinessValueName FROM [dbo].[Dependents], [dbo].[Project] WHERE ProjectName='" + mName + "' AND DependantName=Name");
            while (mReader.Read() )
            {
                mDependencies.Add(new Project(mReader.GetString(0).ToString(), mReader.GetString(1).ToString(), mReader.GetString(2).ToString()));
            }
            mReader.Close();
        }

        public RoadMap(string name )
        {
            mName = name;

            mDatabase.connect();
            mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'");
            mReader.Read();

            mTimeStamp = mReader.GetDateTime(0);
            mDescription = mReader.GetString(1);
            string UID = mReader.GetString(2);

            mDatabase.close();

            mDatabase.connect();
            mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'");
            mReader.Read();

            mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2));

            mDatabase.close();

            mTimeline = new TimeLine(mName);

            //Get the StrategyPoints
            mDatabase.connect();
            mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'");
            while (mReader.Read())
            {
                StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1));
                mStrategyPoints.Add(sp);
            }
            mDatabase.close();
        }

 protected override Exception ProcessSqlResult(SqlDataReader reader)
 {
     Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader);
     if (nextResultSet == null)
     {
         reader.NextResult();
         List<IDictionary<XName, object>> parameters = new List<IDictionary<XName, object>>();
         if (reader.Read())
         {
             do
             {
                 IDictionary<XName, object> item = new Dictionary<XName, object>();
                 item.Add(WorkflowServiceNamespace.SiteName, reader.GetString(0));
                 item.Add(WorkflowServiceNamespace.RelativeApplicationPath, reader.GetString(1));
                 item.Add(WorkflowServiceNamespace.RelativeServicePath, reader.GetString(2));
                 parameters.Add(item);
             }
             while (reader.Read());
         }
         else
         {
             base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasActivatableWorkflowEvent>.Value);
             base.StoreLock.InstanceDetectionTask.ResetTimer(false);
         }
         base.InstancePersistenceContext.QueriedInstanceStore(new ActivatableWorkflowsQueryResult(parameters));
     }
     return nextResultSet;
 }

        /// <summary>
        /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalle class and populates it with data from the specified SqlDataReader.
        /// </summary>
        private static ViewAuditoriaListaVerificacionDetalleInfo MakeViewAuditoriaListaVerificacionDetalle(SqlDataReader dataReader)
        {
            ViewAuditoriaListaVerificacionDetalleInfo viewAuditoriaListaVerificacionDetalle = new ViewAuditoriaListaVerificacionDetalleInfo();

            if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId);
            if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId);
            if (dataReader.IsDBNull(AuditoriaPuntoId) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId);
            if (dataReader.IsDBNull(AuditoriaControlId) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId);
            if (dataReader.IsDBNull(PuntajeRequerido) == false)
                viewAuditoriaListaVerificacionDetalle.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido);
            if (dataReader.IsDBNull(AuditoriaPunto) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaPunto = dataReader.GetString(AuditoriaPunto);
            if (dataReader.IsDBNull(AuditoriaControl) == false)
                viewAuditoriaListaVerificacionDetalle.AuditoriaControl = dataReader.GetString(AuditoriaControl);
            if (dataReader.IsDBNull(Orden) == false)
                viewAuditoriaListaVerificacionDetalle.Orden = dataReader.GetByte(Orden);
            if (dataReader.IsDBNull(Activo) == false)
                viewAuditoriaListaVerificacionDetalle.Activo = dataReader.GetBoolean(Activo);

            return viewAuditoriaListaVerificacionDetalle;
        }

        public bool AuthTest(string username, string password, ref userType theUser)
        {
            bool autorised = false;
            OpenConnection();
            Console.WriteLine("Debugging:");
            soHigh(username, ref password);

            sqlCmd.CommandText = string.Format("select StaffName, Password, StaffTypeID, StaffID from Staff WHERE StaffName='{0}' AND Password='{1}';", username, password);
            sqlCmd.Connection = dbConnection;
            reader = sqlCmd.ExecuteReader();
            if (reader.HasRows) {
                reader.Read();
                if ((username == reader.GetString(0)) && (password == reader.GetString(1))) {
                    userid = reader.GetInt32(3);
                    theUser = (userType)reader.GetInt32(2);
                    autorised = true;

                }
            }
            if(debugging){
            AuthDebugging(username, password);
            }

            CloseConnection();

            return autorised;
        }

        public LoginDB(System.Data.SqlClient.SqlDataReader reader)
        {
            this.reader = reader;
            this.ID = reader.GetInt64(reader.GetOrdinal("Id"));
            this.Login = reader.GetString(reader.GetOrdinal("Login"));
            this.Senha = reader.GetString(reader.GetOrdinal("Senha"));

        }

 /// <summary>
 /// Constructs an instance of IStoreLocation using parts of a row from SqlDataReader.
 /// Used for creating the shard location instance.
 /// </summary>
 /// <param name="reader">SqlDataReader whose row has shard information.</param>
 /// <param name="offset">Reader offset for column that begins shard information.</param>
 internal SqlLocation(SqlDataReader reader, int offset)
 {
     this.Location = new ShardLocation(
         reader.GetString(offset + 1),
         reader.GetString(offset + 3),
         (SqlProtocol)reader.GetInt32(offset),
         reader.GetInt32(offset + 2));
 }