C# OleDb.OleDbDataReader类代码示例

        public PipeDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber)
        {
            //setting parts via a data reader
            ErrorMessages = new List<string>();

            AreaNumber = string.Empty;
            SequenceNumber =string.Empty;
            Class = string.Empty;
            Size = string.Empty;
            FluidCode = string.Empty;
            SpecialFeature =string.Empty;
            PandID = string.Empty;
            From = string.Empty;
            To = string.Empty;
            Category = string.Empty;
            Description = string.Empty;

            mRowNumber = rowNumber;
            mWorkSheetName = workSheetName;

            AreaNumber = dr.SafeString((int)PipeColumn.Area);
            SequenceNumber = dr.SafeString((int)PipeColumn.Sequence);
            Class = dr.SafeString((int)PipeColumn.PipeClass);
            Size = dr.SafeString((int)PipeColumn.Size);
            FluidCode = dr.SafeString((int)PipeColumn.FluidCode);
            SpecialFeature = dr.SafeString((int)PipeColumn.SpecialFeature);

            PandID = dr.SafeString((int)PipeColumn.PID);
            From = dr.SafeString((int)PipeColumn.From);
            To = dr.SafeString((int)PipeColumn.To);
            Category = dr.SafeString((int)PipeColumn.Category);
            Description = dr.SafeString((int)PipeColumn.Description);
            IsActive = dr.SafeNullableBool((int) PipeColumn.IsActive);
        }

 public SignalAttributeMasterBean( OleDbDataReader reader )
     : base(_TABLE_NAME)
 {
     if( fieldMap.ContainsKey(_SIGNAL_ATTRIBUTE_ID) )
         fieldMap[_SIGNAL_ATTRIBUTE_ID] = reader[_SIGNAL_ATTRIBUTE_ID];
     else
         fieldMap.Add(_SIGNAL_ATTRIBUTE_ID, reader[_SIGNAL_ATTRIBUTE_ID]);
     if( fieldMap.ContainsKey(_SIGNAL_ID) )
         fieldMap[_SIGNAL_ID] = reader[_SIGNAL_ID];
     else
         fieldMap.Add(_SIGNAL_ID, reader[_SIGNAL_ID]);
     if( fieldMap.ContainsKey(_ATTRIBUTE_NAME) )
         fieldMap[_ATTRIBUTE_NAME] = reader[_ATTRIBUTE_NAME];
     else
         fieldMap.Add(_ATTRIBUTE_NAME, reader[_ATTRIBUTE_NAME]);
     if( fieldMap.ContainsKey(_DEFAULT_VALUE) )
         fieldMap[_DEFAULT_VALUE] = reader[_DEFAULT_VALUE];
     else
         fieldMap.Add(_DEFAULT_VALUE, reader[_DEFAULT_VALUE]);
     if( fieldMap.ContainsKey(_TYPE) )
         fieldMap[_TYPE] = reader[_TYPE];
     else
         fieldMap.Add(_TYPE, reader[_TYPE]);
     if( fieldMap.ContainsKey(_FIXED_VALUE) )
         fieldMap[_FIXED_VALUE] = reader[_FIXED_VALUE];
     else
         fieldMap.Add(_FIXED_VALUE, reader[_FIXED_VALUE]);
     initialize();
 }

 public void loadData()
 {
     try
     {
         lvexaminee.Items.Clear();
         //OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=db.accdb");
         conn.Open();
         OleDbCommand cmd = new OleDbCommand("SELECT * FROM examineetbl", conn);
         OleDbDataReader dr;
         dr = cmd.ExecuteReader();
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 lvexaminee.Items.Add(dr[0].ToString());
                 lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[1].ToString());
                 lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[2].ToString());
                 lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[3].ToString());
                 lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[4].ToString());
                 lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[8].ToString());
             }
         }
         dr.Close();
         conn.Close();
     }
     catch (OleDbException ex)
     {
         MessageBox.Show(ex.Message);
         throw;
     }
 }

        public VendorDataAdapter(OleDbDataReader dr, int rowNumber)
        {
            ErrorMessages = new List<string>();

            //Name
            Name = dr.SafeString((int)VendorColumn.VendorName);
            if (String.IsNullOrEmpty(Name))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorName, rowNumber));
            }

            //Number
            string numberString = string.Empty;
            numberString = dr.SafeString((int)VendorColumn.VendorNumber);
            int number;

            if (int.TryParse(numberString, out number))
            {
                Number = number;
            }
            else
            {
                ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to number. Rown number '{2}'. Skipping ", VendorColumn.VendorNumber, numberString, rowNumber));
            }

            //City
            City = dr.SafeString((int)VendorColumn.VendorCity);
            if (String.IsNullOrEmpty(City))
            {
                ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorCity, rowNumber));
            }
        }

 public InstrumentBean( OleDbDataReader reader )
     : base(_TABLE_NAME)
 {
     if( fieldMap.ContainsKey(_INSTRUMENT_UUID) )
         fieldMap[_INSTRUMENT_UUID] = reader[_INSTRUMENT_UUID];
     else
         fieldMap.Add(_INSTRUMENT_UUID, reader[_INSTRUMENT_UUID]);
     if( fieldMap.ContainsKey(_INSTRUMENT_NAME) )
         fieldMap[_INSTRUMENT_NAME] = reader[_INSTRUMENT_NAME];
     else
         fieldMap.Add(_INSTRUMENT_NAME, reader[_INSTRUMENT_NAME]);
     if( fieldMap.ContainsKey(_MODEL_NAME) )
         fieldMap[_MODEL_NAME] = reader[_MODEL_NAME];
     else
         fieldMap.Add(_MODEL_NAME, reader[_MODEL_NAME]);
     if( fieldMap.ContainsKey(_ATML) )
         fieldMap[_ATML] = reader[_ATML];
     else
         fieldMap.Add(_ATML, reader[_ATML]);
     if( fieldMap.ContainsKey(_DESCRIPTION) )
         fieldMap[_DESCRIPTION] = reader[_DESCRIPTION];
     else
         fieldMap.Add(_DESCRIPTION, reader[_DESCRIPTION]);
     if( fieldMap.ContainsKey(_PART_NUMBER) )
         fieldMap[_PART_NUMBER] = reader[_PART_NUMBER];
     else
         fieldMap.Add(_PART_NUMBER, reader[_PART_NUMBER]);
     initialize();
 }

 public TestSignalLibraryBean( OleDbDataReader reader )
     : base(_TABLE_NAME)
 {
     if( fieldMap.ContainsKey(_ID) )
         fieldMap[_ID] = reader[_ID];
     else
         fieldMap.Add(_ID, reader[_ID]);
     if( fieldMap.ContainsKey(_LIBRARY_NAME) )
         fieldMap[_LIBRARY_NAME] = reader[_LIBRARY_NAME];
     else
         fieldMap.Add(_LIBRARY_NAME, reader[_LIBRARY_NAME]);
     if( fieldMap.ContainsKey(_CONTENT) )
         fieldMap[_CONTENT] = reader[_CONTENT];
     else
         fieldMap.Add(_CONTENT, reader[_CONTENT]);
     if( fieldMap.ContainsKey(_FILE_NAME) )
         fieldMap[_FILE_NAME] = reader[_FILE_NAME];
     else
         fieldMap.Add(_FILE_NAME, reader[_FILE_NAME]);
     if( fieldMap.ContainsKey(_LAST_UPDATE) )
         fieldMap[_LAST_UPDATE] = reader[_LAST_UPDATE];
     else
         fieldMap.Add(_LAST_UPDATE, reader[_LAST_UPDATE]);
     if( fieldMap.ContainsKey(_TARGET_NAMESPACE) )
         fieldMap[_TARGET_NAMESPACE] = reader[_TARGET_NAMESPACE];
     else
         fieldMap.Add(_TARGET_NAMESPACE, reader[_TARGET_NAMESPACE]);
     initialize();
 }

 public SignalMasterBean( OleDbDataReader reader )
     : base(_TABLE_NAME)
 {
     if( fieldMap.ContainsKey(_SIGNAL_ID) )
         fieldMap[_SIGNAL_ID] = reader[_SIGNAL_ID];
     else
         fieldMap.Add(_SIGNAL_ID, reader[_SIGNAL_ID]);
     if( fieldMap.ContainsKey(_SIGNAL_NAME) )
         fieldMap[_SIGNAL_NAME] = reader[_SIGNAL_NAME];
     else
         fieldMap.Add(_SIGNAL_NAME, reader[_SIGNAL_NAME]);
     if( fieldMap.ContainsKey(_PARENT_SIGNAL_ID) )
         fieldMap[_PARENT_SIGNAL_ID] = reader[_PARENT_SIGNAL_ID];
     else
         fieldMap.Add(_PARENT_SIGNAL_ID, reader[_PARENT_SIGNAL_ID]);
     if( fieldMap.ContainsKey(_XMLNS) )
         fieldMap[_XMLNS] = reader[_XMLNS];
     else
         fieldMap.Add(_XMLNS, reader[_XMLNS]);
     if( fieldMap.ContainsKey(_UUID) )
         fieldMap[_UUID] = reader[_UUID];
     else
         fieldMap.Add(_UUID, reader[_UUID]);
     initialize();
 }

 /// <summary>
 /// Opens the connection to the database.
 /// </summary>
 static void openconnection()
 {
     dr = null;
     String ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Public\\TRManager\\IncidentDB.accdb;Persist Security Info=False;";
     connection = new OleDbConnection(ConnectionString);
     connection.Open();
 }

        public void populaLista()
        {
            rsPlay = objBD.ExecutaSQL("select PLI_ID, PLI_TITULO, PLI_URL from PlayList where PLI_ATIVO = 1 order by PLI_DH_CADASTRO desc");
            if (rsPlay == null)
            {
                throw new Exception();
            }
            if (rsPlay.HasRows)
            {
                while (rsPlay.Read())
                {
                    if (aux == 1)
                    {
                        objVideo.InnerHtml += "<iframe width=\"480\" height=\"269\" src=\""+rsPlay["PLI_URL"].ToString()+"\" frameborder=\"0\" allowfullscreen></iframe>";
                    }

                    System.Web.UI.WebControls.ListItem R = new System.Web.UI.WebControls.ListItem();
                    R.Value = rsPlay["PLI_ID"].ToString();
                    R.Text = rsPlay["PLI_TITULO"].ToString();
                    slPlayList.Items.Add(R);
                    aux++;
                }
            }
            rsPlay.Close();
            rsPlay.Dispose();
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            objUtils = new utils();
            objBD = new bd();

            switch (Request["acao"])
            {
                case ("editar"):
                    rsLista = objBD.ExecutaSQL("select EQU_ID, EQU_NOME, EQU_DESCRICAO from  Equipe where EQU_ID ='" + Request["EQU_ID"] + "'");
                    if (rsLista == null)
                    {
                        throw new Exception();
                    }
                    if (rsLista.HasRows)
                    {
                        rsLista.Read();
                        Response.Write(rsLista["EQU_ID"] + "|" + rsLista["EQU_NOME"] + "|" + rsLista["EQU_DESCRICAO"]);
                    }
                    break;

                default:
                    PopulaLista();

                    break;
            }
        }

        public void Ultimas()
        {
            rsLista = objBD.ExecutaSQL("select top 3  F.FTO_ID, U.USU_NOME, U.USU_USUARIO, FME_MENSAGEM, CONVERT(VARCHAR(10),FME_DH_PUBLICACAO, 103) AS FME_DH_PUBLICACAO, T.FTO_TITULO from ForumMensagem F inner join ForumTopicos T on (T.FTO_ID = F.FTO_ID) inner join Usuario U ON (U.USU_ID = F.USU_ID) where RED_ID = " + Session["redeID"] + " and F.FME_ATIVO = 1 order by F.FME_DH_PUBLICACAO desc");

            if (rsLista == null)
            {
                throw new Exception();
            }
            if (rsLista.HasRows)
            {
                while (rsLista.Read())
                {
                    ultimasMensagens.InnerHtml += " <div class=\"txt blog_txt txt_forum\">";
                    ultimasMensagens.InnerHtml += "   <div class=\"txt\">";
                    ultimasMensagens.InnerHtml += "       <a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\"><p>" + objUtils.CortarString(true, 100, rsLista["FME_MENSAGEM"].ToString()) + "</p></a>";
                    ultimasMensagens.InnerHtml += "       <p class=\"destque_forum\">Mensagem enviada por: <a href='/perfil/" + rsLista["USU_USUARIO"].ToString() + "' title='" + rsLista["USU_NOME"].ToString() + "'>" + rsLista["USU_NOME"].ToString() + "</a></p>";
                    ultimasMensagens.InnerHtml += "       <p class=\"destque_forum\">Enviada em: <b>" + rsLista["FME_DH_PUBLICACAO"].ToString() + "</b></p>";
                    ultimasMensagens.InnerHtml += "       <p class=\"destque_forum\">Tópico: <b><a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\">" + rsLista["FTO_TITULO"].ToString() + "</a></b></p><br /><br />";
                    ultimasMensagens.InnerHtml += "   </div>";
                    ultimasMensagens.InnerHtml += " </div>";
                }
            }
            rsLista.Close();
            rsLista.Dispose();
        }

 private void actualizador()
 {
     Conector();
     comando.CommandText = "select * from t_articulos";
     Lector = comando.ExecuteReader();
     int registros = 0;
              while (Lector.Read() == true)
     {
         DatosCosa[registros]=new Articulo();
         //Cosa = new Articulo();
         DatosCosa[registros].CodigoArti = Convert.ToInt32(Lector["id_articulo"]);
         DatosCosa[registros].NombreArti = Lector["n_articulo"].ToString();
         DatosCosa[registros].Precio = Convert.ToDouble(Lector["precio"]);
        // DatosCosa[registros] = Cosa;
         registros++;
     }
     Lector.Close();
     comando.CommandText = "select * from t_clientes";
     Lector = comando.ExecuteReader();
     registros = 0;
        // DatosFulano = new Clientes[50];
     while (Lector.Read() == true)
     {//Fulano=new Clientes();
         DatosFulano[registros]=new Clientes();
         DatosFulano[registros].Barrio=Convert.ToInt32(Lector["id_barrio"]);
         DatosFulano[registros].Calle=Lector["calle"].ToString();
         DatosFulano[registros].CodigoClle=Convert.ToInt32(Lector["id_cliente"]);
         DatosFulano[registros].NombreClie=Lector["n_cliente"].ToString();
         DatosFulano[registros].NumeroCa=Convert.ToInt32(Lector["calle_nro"]);
         //DatosFulano[registros]=Fulano;
         registros++;
     }
     Lector.Close();
     conexion.Close();
 }

        protected void Button1_Click1(object sender, EventArgs e)
        {
            string strGroupName, strGroupContent;

            DateTime dtmCreateDate;

            if (txtGroupName.Text == "")
            {
                this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写群组名称！')</script>");
                return;
            }

            strGroupName = txtGroupName.Text;
            strGroupContent = txtGroupName.Text;

            string strsql;
            myGroup = AccessDateHelper.ExecuteReader("select * from [Group] where UserID=" + Convert.ToInt16(myUserID) + "");
            if (myGroup.Read())
            {
                strsql = "update [Group] set GroupName='" + strGroupName + "',GroupContent='" + strGroupContent + "' where GroupID=" + Convert.ToInt16(myGroup["GroupID"]) + "";
            }
            else
            {
                strsql = "insert into [Group] (GroupName,GroupContent,UserID) values ('" + strGroupName + "','" + strGroupContent + "',"+Convert.ToInt16(myUserID)+")";
            }

            if (AccessDateHelper.ExecuteNonQuery(strsql) > 0)
            {
                this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('群组更改成功！');try{ window.opener.RefreshForm() }catch(e){};</script>");
            }
            else
            {
                this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('新建试题失败！')</script>");
            }
        }

    protected void Button1_Click(object sender, EventArgs e)
    {
        conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
        string u_name, password;
        u_name = TextBox1.Text;
        password = TextBox2.Text;
        rec_mail rr = new rec_mail();
        string comp=rr.un_enc(u_name, password);
        //u_name = raw_u_name + password[2];
        //Response.Write(u_name);
        conn.Open();
        cmd=new OleDbCommand ("select enc_fun(user_id,password) from username where user_id='"+ u_name +"'",conn);
        dr = cmd.ExecuteReader();
        //dr.Read();
        //Response.Write(raw_u_name + dr["password"].ToString()[2]);
        if (dr.HasRows == false)
            Label2.Visible = true;
        else
        {
            dr.Read();

            if (dr[0].ToString() == comp)
            {
                Session["us_name"] = u_name;
                Response.Redirect("Mail_box.aspx");
            }
            else
                Label2.Visible = true;
        }
        dr.Close();
        conn.Close();
    }

 //Constructor - Initializes the object with data and connects to the database.
 public MeasurementUncertainityCalculator()
 {
     string path;
     path = Path.GetDirectoryName(Application.ExecutablePath);
     try
     {
         connection = new OleDbConnection();
         connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DB\\UC.mdb;Persist Security Info=False";
         connection.Open();
         command = new OleDbCommand();
         command.Connection = connection;
         command.CommandText = "SELECT count(Sample_Number) FROM InputTable";
         reader = command.ExecuteReader();
         while (reader.Read())
         {
             no_of_obs = (Double.Parse(reader[0].ToString()));
         }
         reader.Close();
         reader = null;
     }
     catch (Exception e)
     {
         Console.WriteLine(e.Message);
     }
 }