C# OleDb.OleDbDataReader类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中System.Data.OleDb.OleDbDataReader类的典型用法代码示例。如果您正苦于以下问题：C# OleDbDataReader类的具体用法？C# OleDbDataReader怎么用？C# OleDbDataReader使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

OleDbDataReader类属于System.Data.OleDb命名空间，在下文中一共展示了OleDbDataReader类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: PipeDataAdapter

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

开发者ID:barrett2474，项目名称:CMS2，代码行数:34，代码来源:PipeDataAdapter.cs

示例2: SignalAttributeMasterBean

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

开发者ID:UtrsSoftware，项目名称:ATMLWorkBench，代码行数:29，代码来源:SignalAttributeMasterBean.cs

示例3: loadData

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

开发者ID:keitz14，项目名称:EntranceExam，代码行数:31，代码来源:ExamineeForm.cs

示例4: VendorDataAdapter

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

开发者ID:barrett2474，项目名称:CMS2，代码行数:32，代码来源:VendorDataAdapter.cs

示例5: InstrumentBean

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

开发者ID:UtrsSoftware，项目名称:ATMLWorkBench，代码行数:29，代码来源:InstrumentBean.cs

示例6: TestSignalLibraryBean

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

开发者ID:UtrsSoftware，项目名称:ATMLWorkBench，代码行数:29，代码来源:TestSignalLibraryBean.cs

示例7: SignalMasterBean

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

开发者ID:UtrsSoftware，项目名称:ATMLWorkBench，代码行数:25，代码来源:SignalMasterBean.cs

示例8: ElectricalDataAdapter

        public ElectricalDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType)
        {
            RowNumber = rowNumber;
            WorkSheetName = workSheetName;

            Tag = dr.SafeString((int) EquipmentColumn.Tag).Trim();
            EquipmentType = dr.SafeString((int) EquipmentColumn.Type).Trim();
            Description = dr.SafeString((int) EquipmentColumn.Description).Trim();
            Notes = dr.SafeString((int) EquipmentColumn.Notes);
            AreaNumber = dr.SafeString((int)EquipmentColumn.Area).Trim();
            Specification = dr.SafeString((int)EquipmentColumn.Spec).Trim();
            PandID = dr.SafeString((int)EquipmentColumn.PID).Trim();
            MaintSysId = dr.SafeString((int)EquipmentColumn.MaintSysId);

            string classifiedString = dr.SafeString((int)EquipmentColumn.Classified);
            bool classified;
            if (bool.TryParse(classifiedString, out classified))
            {
                Classified = classified;
            }

            string isActiveString = dr.SafeString((int)EquipmentColumn.IsActive);
            bool isActive;
            if (bool.TryParse(isActiveString, out isActive))
            {
                IsActive = isActive;
            }

            Validate(importType==CommonUtils.ImportType.CreateElectrical);
        }

开发者ID:barrett2474，项目名称:CMS2，代码行数:30，代码来源:ElectricalDataAdapter.cs

示例9: InterlockDataAdapter

        public InterlockDataAdapter(OleDbDataReader dr ,IList<string> dynamicList, int startColumn)
        {
            ControlSystemName = string.Empty;
            InterlockTypeName =
            Number = string.Empty;
            Cause = string.Empty;
            Description = string.Empty;

            ControlSystemName = dr.SafeString((int)InterlockColumn.ControlSystemName).Trim();
            InterlockTypeName = dr.SafeString((int)InterlockColumn.InterlockType).Trim();
            Number = dr.SafeString((int)InterlockColumn.Number).Trim();
            Cause = dr.SafeString((int)InterlockColumn.Cause).Trim();
            Description = dr.SafeString((int)InterlockColumn.Description).Trim();

            DynamicProperties = new List<DynamicProperty>();

            if (dynamicList != null && dynamicList.Any())
            {
                for (int d = 0; d < dynamicList.Count(); d++)
                {
                    string p = dynamicList[d];

                    DynamicProperty property = new DynamicProperty();

                    property.PropertyName = p;
                    property.PropertyValue = dr.SafeString(startColumn + d);

                    DynamicProperties.Add(property);
                }
            }
        }

开发者ID:barrett2474，项目名称:CMS2，代码行数:31，代码来源:InterlockDataAdapter.cs

示例10: openconnection

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

开发者ID:UristMcMiner，项目名称:SE-Projekt_RWB.csharp，代码行数:10，代码来源:UtilityDB.cs

示例11: populaLista

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

开发者ID:kaizonaro，项目名称:palavracantada，代码行数:26，代码来源:videos.aspx.cs

示例12: Page_Load

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

开发者ID:kaizonaro，项目名称:palavracantada，代码行数:26，代码来源:palavra-cantada.aspx.cs

示例13: Ultimas

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

开发者ID:kaizonaro，项目名称:palavracantada，代码行数:25，代码来源:forum.aspx.cs

示例14: actualizador

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

开发者ID:aaferrari，项目名称:Ejercicios，代码行数:35，代码来源:FrmTransacion.cs

示例15: Button1_Click1

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

开发者ID:huaminglee，项目名称:NET-KaoShi，代码行数:35，代码来源:MyGroup.aspx.cs

示例16: Button1_Click

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

开发者ID:vedsarkushwaha，项目名称:MyDaak，代码行数:32，代码来源:Default.aspx.cs

示例17: MeasurementUncertainityCalculator

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

开发者ID:GreatDharmatma，项目名称:Projects，代码行数:26，代码来源:MeasurementUncertainityCalculator.cs

示例18: BookCatalog_Load

        private void BookCatalog_Load(object sender, EventArgs e)
        {
            try{
              // creating a connection
            sConn = " Provider=Microsoft.ACE.OLEDB.12.0 ; Data Source = finalprojectC#.accdb";
            OleDbConnection dbConn = new OleDbConnection(sConn);
            dbConn.Open();
            // creating a sql query
             sql = "SELECT * FROM Books_online ORDER BY  BookName ASC, Book_Price ASC;";
             OleDbCommand  dbCmd = new OleDbCommand();
             dbCmd.CommandText = sql;
             dbCmd.Connection = dbConn;

               //Create a dbreader object
             dbReader = dbCmd.ExecuteReader();
            while (dbReader.Read())
                {
               // adding book name and price to listbox

                    fprice = Convert.ToDouble(dbReader["Book_Price"]);
                    this.listBox1.Items.Add(dbReader["BookName"].ToString() + "  " + "$" + dbReader["Book_Price"]);

               }

            dbReader.Close();
            dbConn.Close();
            }
             catch (System.Exception exc)
             {
              label1.Text = exc.Message;
             }
        }

开发者ID:esitamon，项目名称:final-project-C-，代码行数:32，代码来源:BookCatalog.cs

示例19: listarBanner

        public void listarBanner(int RED_ID)
        {
            try
            {
                rsBanner = objBD.ExecutaSQL("EXEC site_psBanner "+RED_ID+" ");

                if (rsBanner == null)
                {
                    throw new Exception();
                }
                if (rsBanner.HasRows)
                {
                    while (rsBanner.Read())
                    {
                       banner.InnerHtml += "<div class='banner'>";
                       banner.InnerHtml += "    <a href='" + rsBanner["BAN_LINK"] + "' title='" + rsBanner["BAN_LEGENDA"] + "'><img width='752px' height='208px' src='/upload/imagens/banners/" + rsBanner["BAN_IMAGEM"] + "' alt='" + rsBanner["BAN_LEGENDA"] + "'/></a>";
                       banner.InnerHtml += "</div>";
                    }
                }
                rsBanner.Close();
                rsBanner.Dispose();
            }
            catch (Exception)
            {
                throw;
            }
        }

开发者ID:kaizonaro，项目名称:palavracantada，代码行数:27，代码来源:header.ascx.cs

示例20: ListarConfig

        public void ListarConfig(string ID)
        {
            if (string.IsNullOrWhiteSpace(ID) == false)
            {
                rsConfig = objBD.ExecutaSQL("EXEC site_psListarConfig " + ID);
                if (rsConfig == null)
                {
                    throw new Exception();
                }
                if (rsConfig.HasRows)
                {
                    rsConfig.Read();
                    USU_ID.Attributes.Add("value", rsConfig["USU_ID"].ToString());
                    USU_NOME.Attributes.Add("value", rsConfig["USU_NOME"].ToString());
                    USU_EMAIL.Attributes.Add("value", rsConfig["USU_EMAIL"].ToString());

                    ListItem li = CAR_ID.Items.FindByValue(rsConfig["CAR_ID"].ToString());
                    li.Selected = true;

                    //pivacidade
                    if (rsConfig["PRI_PERFIL"].ToString() == "True") { sim_perfil.Checked = true; } else { nao_perfil.Checked = true; }
                    if (rsConfig["PRI_BLOG"].ToString() == "True") { sim_blog.Checked = true; } else { nao_blog.Checked = true; }
                    if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_midia.Checked = true; } else { nao_midia.Checked = true; }
                    if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_video.Checked = true; } else { nao_video.Checked = true; }
                    //notificaoes
                    if (rsConfig["NOT_BLOG"].ToString() == "True") { sim_blog2.Checked = true; } else { nao_blog2.Checked = true; }
                    if (rsConfig["NOT_GALERIA"].ToString() == "True") { sim_galeria.Checked = true; } else { nao_galeria.Checked = true; }
                    if (rsConfig["NOT_FORUM"].ToString() == "True") { sim_forum.Checked = true; } else { nao_forum.Checked = true; }
                    if (rsConfig["NOT_DOCUMENTADAS"].ToString() == "True") { sim_criacao.Checked = true; } else { nao_criacao.Checked = true; }

                    InsereCategoria(infantil);
                    InsereCategoria(fundamental);
                }
            }
        }

开发者ID:kaizonaro，项目名称:palavracantada，代码行数:35，代码来源:editar_config.aspx.cs

注：本文中的System.Data.OleDb.OleDbDataReader类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# OleDb.OleDbParameter类代码示例发布时间：2022-05-26

C# OleDb.OleDbDataAdapter类代码示例发布时间：2022-05-26

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19297|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：10023|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8345|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8715|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8660|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9692|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8649|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：8017|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8686|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7551|2022-11-06

客服电话

电子邮件

C# OleDb.OleDbDataReader类代码示例

示例1: PipeDataAdapter

示例2: SignalAttributeMasterBean

示例3: loadData

示例4: VendorDataAdapter

示例5: InstrumentBean

示例6: TestSignalLibraryBean

示例7: SignalMasterBean

示例8: ElectricalDataAdapter

示例9: InterlockDataAdapter

示例10: openconnection

示例11: populaLista

示例12: Page_Load

示例13: Ultimas

示例14: actualizador

示例15: Button1_Click1

示例16: Button1_Click

示例17: MeasurementUncertainityCalculator

示例18: BookCatalog_Load

示例19: listarBanner

示例20: ListarConfig

请发表评论

全部评论

上一篇：

下一篇：

Delphi与C之间的类型对应表

librespeed/speedtest: Self-hosted Speedt

央的笔顺,解析央的笔画,说说央的部首

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053