C# OleDbCommand.Dispose方法代码示例

        public static int SaveRecord(string sql)
        {
            const int rv = 0;
            try
            {
                string connectionString = ConfigurationManager.ConnectionStrings["LA3Access"].ConnectionString;
                using (var conn = new OleDbConnection(connectionString))
                {
                    conn.Open();
                    var cmGetID = new OleDbCommand("SELECT @@IDENTITY", conn);
                    var comm = new OleDbCommand(sql, conn) { CommandType = CommandType.Text };
                    comm.ExecuteNonQuery();

                    var ds = new DataSet();
                    var adapt = new OleDbDataAdapter(cmGetID);
                    adapt.Fill(ds);
                    adapt.Dispose();
                    cmGetID.Dispose();

                    return int.Parse(ds.Tables[0].Rows[0][0].ToString());

                }
            }
            catch (Exception)
            {
            }
            return rv;
        }

 private void btnOk_Click(object sender, EventArgs e)
 {
     string sql = "select * from [staff] where [scode][email protected] and [password][email protected]";
     OleDbCommand cmd = new OleDbCommand(sql, DataAccess.getInstance().getDataConnection());
     cmd.Parameters.AddWithValue("scode", ((StaffModel) cboUsername.SelectedValue).Value);
     cmd.Parameters.AddWithValue("password", txtPassword.Text);
     OleDbDataReader rdr = cmd.ExecuteReader();
     if (rdr.Read())
     {
         if(!rdr.GetBoolean(rdr.GetOrdinal("isactive")))
         {
             MessageBox.Show("Your account has been deactivated. Please consult your administration regarding this");
             rdr.Close();
             cmd.Dispose();
             return;
         }
         Program.loginStaff = new StaffModel(rdr.GetInt32(rdr.GetOrdinal("staffno")), rdr.GetString(rdr.GetOrdinal("scode")), rdr.GetString(rdr.GetOrdinal("sname")), "");
         rdr.Close();
         cmd.Dispose();
         graceClose = true;
         Close();
     }
     else
     {
         MessageBox.Show("You have supply a wrong credential", Application.ProductName);
         return;
     }
 }

        public bool IsValidModerator(string login, string password)
        {
            var conn =
                new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|Użytkownicy.accdb");
            var cmd = new OleDbCommand("SELECT [Login] FROM [Users] " + @"WHERE [Login] = @l AND [Hasło] = @p AND [Prawa] = @a") { Connection = conn };
            cmd.Parameters.Clear();
            cmd.Parameters.Add(new OleDbParameter("@l", OleDbType.VarWChar)).Value = login;
            cmd.Parameters.Add(new OleDbParameter("@p", OleDbType.VarWChar)).Value = password;
            cmd.Parameters.Add(new OleDbParameter("@a", OleDbType.VarWChar)).Value = "Moderator";
            conn.Open();

            var reader = cmd.ExecuteReader();

            if (reader != null && reader.HasRows)
            {
                reader.Dispose();
                cmd.Dispose();
                return true;
            }
            else
            {
                reader?.Dispose();
                cmd.Dispose();
                return false;
            }
        }

        /// <summary>
        /// Executes an inline SQL statement and returns a data table.
        /// </summary>
        /// <param name="dbStatement">Inline SQL</param>
        /// <param name="connectionString">Connection string</param>
        /// <returns>Data table containing the return data</returns>
        public static DataTable RunQuery(string dbStatement, string connectionString)
        {
            OleDbConnection dbConnection = null;
            OleDbCommand dbCommand = null;
            OleDbDataAdapter adapter = null;
            DataTable dt = null;

            try
            {
                dbConnection = new OleDbConnection(connectionString);
                dbCommand = new OleDbCommand(dbStatement, dbConnection);
                dbCommand.CommandType = CommandType.Text;
                dbCommand.CommandTimeout = 600;

                adapter = new OleDbDataAdapter(dbCommand);
                dt = new DataTable();

                dbConnection.Open();
                adapter.Fill(dt);
                return dt;
            }
            finally
            {
                if (adapter != null)
                    adapter.Dispose();
                if (dbCommand != null)
                    dbCommand.Dispose();
                if (dbConnection != null)
                    dbConnection.Dispose();
            }
        }

        //Retourne les stats
        public static Statistique getSats(int noJoueur)
        {
            Statistique stat = null;
            OleDbConnection connexion = new OleDbConnection(connBD);
            try
            {
                connexion.Open();
                commande = new OleDbCommand("SELECT * FROM tblStatistique WHERE [email protected]", connexion);
                commande.Parameters.Add("@noJoueur", OleDbType.Integer).Value = noJoueur;

                OleDbDataReader reader = commande.ExecuteReader();
                while (reader.Read())
                {
                    int nbGagne = reader["nbPartieGagne"] == DBNull.Value ? 0 : Convert.ToInt32(reader["nbPartieGagne"]);
                    int nbPerdu = reader["nbPartiePerdu"] == DBNull.Value ? 0 : Convert.ToInt32(reader["nbPartiePerdu"]);
                    int score = reader["score"] == DBNull.Value ? 0 : Convert.ToInt32(reader["score"]);
                    stat = new Statistique(nbGagne, nbPerdu, score);
                }

                return stat;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                commande.Dispose();
                connexion.Close();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (Session["oturumid"] == null)
                Response.Redirect("giris.aspx");
            else if (Session["oturumdurum"].ToString() == "1")
                Response.Redirect("adminpaneli.aspx");
            else
            {
                string fid = (sender as Button).CommandArgument;
                string kid = Session["oturumid"].ToString();
                string sepet = "";

                OleDbConnection cnn = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=" + Server.MapPath("App_Data/database.mdb"));
                cnn.Open();
                OleDbCommand cmd = new OleDbCommand("select sepet from uyeler where uyeid=" + kid, cnn);
                OleDbDataReader rdr = cmd.ExecuteReader();
                rdr.Read();
                sepet = rdr[0].ToString();
                if (sepet == "")
                    sepet = fid;
                else
                    sepet += "," + fid;

                cmd.Dispose();
                cmd = new OleDbCommand("update uyeler set sepet='" + sepet + "' where uyeid=" + kid, cnn);
                cmd.ExecuteNonQuery();
                cnn.Close();
                Session.Add("um", "Fotoğraf sepetinize eklendi. İyi alışverişler.");
                Response.Redirect("uyepaneli.aspx");
            }
        }

        private void btnNew_Click( object sender, EventArgs e )
        {
            if( Program.UserType == UserType.Customer )
                return;

            AddDlg dlg = new AddDlg();
            if( dlg.ShowDialog( this ) != DialogResult.OK )
                return;

            RefillComboBoxes();

            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "select top 1 * from WedDress order by [ID] desc";
            cmd.Connection = Program.Database;
            cmd.CommandType = CommandType.Text;

            OleDbDataAdapter oda = new OleDbDataAdapter( cmd);
            DataTable dt = new DataTable();
            oda.Fill( dt );

            dsDress.Tables["WedDress"].Merge( dt );
            dt.Dispose();
            oda.Dispose();
            cmd.Dispose();
        }

        private void btnDel_Click( object sender, EventArgs e )
        {
            if( Program.UserType != UserType.Admin )
                return;

            if( dataGridView.CurrentRow == null )
                return;

            int id = (int)dataGridView.CurrentRow.Cells[0].Value;
            DataTable dt = dsDress.Tables["WedDress"];
            DataRow[] rows = dt.Select( "[ID]=" + id );
            if( rows.GetLength( 0 ) <= 0 )
                return;

            if( MessageBox.Show( this, "��ȷʵҪɾ��ѡ���ķ�װ��?", Program.AppTitle,
                MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2 )
                == DialogResult.No )
                return;

            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "delete from [WedDress] where [ID]=" + id.ToString();
            cmd.CommandType = CommandType.Text;
            cmd.Connection = Program.Database;
            cmd.ExecuteNonQuery();
            cmd.Dispose();

            dt.Rows.Remove( rows[0] );
        }

 public static int ExecuteSql(string SQLString)
 {
     int num2;
     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand command = new OleDbCommand(SQLString, connection);
         try
         {
             connection.Open();
             num2 = command.ExecuteNonQuery();
         }
         catch (OleDbException exception)
         {
             connection.Close();
             throw new Exception(exception.Message);
         }
         finally
         {
             if (command != null)
             {
                 command.Dispose();
             }
         }
     }
     return num2;
 }

        public NewRentDlg( int nDressId, DateTime date )
        {
            m_nDressId = nDressId;
            m_date = date;
            m_bModify = true;

            InitializeComponent();

            OleDbCommand oc = new OleDbCommand();
            oc.CommandText = "select startdate, enddate, customer from rent where dressid=? and ? between startdate and enddate";
            oc.CommandType = CommandType.Text;
            oc.Connection = Program.Database;
            oc.Parameters.Add( "a", OleDbType.Integer ).Value = m_nDressId;
            oc.Parameters.Add( "b", OleDbType.Date ).Value = date;

            OleDbDataReader reader = oc.ExecuteReader();
            reader.Read();
            dtStartDate.Value = reader.GetDateTime( 0 );
            dtEndDate.Value = reader.GetDateTime( 1 );
            txtCustomer.Text = reader.GetString( 2 );
            reader.Dispose();
            oc.Dispose();

            this.Text = "�޸ij�����Ϣ";
        }

 /// <summary>
 /// kjhkdfhgkjh
 /// </summary>
 /// <param name="sSQL"></param>
 /// <param name="conecOledb"></param>
 /// <returns> Ele retorna algo de bom</returns>
 protected static OleDbDataReader cria_DataReader_OleDb(String sSQL, OleDbConnection conecOledb)
 {
     OleDbCommand comando = new OleDbCommand(sSQL, conecOledb);
     OleDbDataReader dr = comando.ExecuteReader(CommandBehavior.CloseConnection);
     comando.Dispose();
     return dr;
 }

 private void AttributesForm_Load(object sender, EventArgs e)
 {
     try
     {
         OleDbCommand command = new OleDbCommand(srcCommand, Con);
         this.attributeSchemaXml = Convert.ToString(command.ExecuteScalar());
         command.Dispose();
         this.attributeSet = new DataSet("AttributesSet");
         if ((this.attributeSchemaXml == null) || (this.attributeSchemaXml.Length < 1))
         {
             this.attributesTable = this.attributeSet.Tables.Add("AttributesTable");
             this.attributesTable.Columns.Add("Attribute Name");
             this.attributesTable.Columns.Add("Attribute Value");
             DataRow row = this.attributesTable.NewRow();
             row["Attribute Name"] = "Enter name Of attribute";
             row["Attribute Value"] = "Enter attribute value";
             this.attributesTable.Rows.Add(row);
             this.AttributesGrid.SetDataBinding(this.attributeSet, this.attributeSet.Tables[0].TableName);
         }
         else
         {
             this.attributeSet.ReadXml(new XmlTextReader(new StringReader(this.attributeSchemaXml)));
             this.attributeSchemaXml = null;
             this.AttributesGrid.SetDataBinding(this.attributeSet, this.attributeSet.Tables[0].TableName);
         }
     }
     catch (Exception exception)
     {
         BusinessLogic.MyMessageBox(exception.Message);
     }
 }

 /// <summary>
 /// 执行带一个存储过程参数的的SQL语句。
 /// </summary>
 /// <param name="SQLString">SQL语句</param>
 /// <param name="content">参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</param>
 /// <returns>影响的记录数</returns>
 public static int ExecuteSql(string SQLString, string content)
 {
     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand cmd = new OleDbCommand(SQLString, connection);
         System.Data.OleDb.OleDbParameter myParameter = new System.Data.OleDb.OleDbParameter("@content", OleDbType.VarChar);
         myParameter.Value = content;
         cmd.Parameters.Add(myParameter);
         try
         {
             connection.Open();
             int rows = cmd.ExecuteNonQuery();
             return rows;
         }
         catch (System.Data.OleDb.OleDbException E)
         {
             throw new Exception(E.Message);
         }
         finally
         {
             cmd.Dispose();
             connection.Close();
         }
     }
 }

        /// <summary>
        /// Execute  Insert,Update
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="cmdParams"></param>
        /// <returns></returns>
        public static int ExecuteNonQuery(string strSql, params OleDbParameter[] cmdParams)
        {
            OleDbConnection sqlCon = OleDbConnect();
            OleDbCommand sqlCmd = new OleDbCommand(strSql, sqlCon);
            sqlCmd.CommandType = CommandType.Text;

            //OleDbTransaction trans = sqlCon.BeginTransaction();
            //sqlCmd.Transaction = trans;
            if (cmdParams != null)
            {
                foreach (OleDbParameter parm in cmdParams)
                {
                    sqlCmd.Parameters.Add(parm);
                }
            }

            try
            {
                sqlCon.Open();
                int num = sqlCmd.ExecuteNonQuery();
                //trans.Commit();
                return num;
            }
            catch
            {
                //trans.Rollback();
                return 0;
            }
            finally
            {
                sqlCmd.Dispose();
                sqlCon.Close();
                sqlCon.Dispose();
            }
        }

    public String[] GetFirstnames()
    {
        List<string> items = new List<string>();
        string strSQL = "";

        OleDbDataReader objReader = null;
        OleDbConnection objConn = null;
        OleDbCommand objCommand = null;

        strSQL = "SELECT firstname from Employees ORDER BY firstname";
        objConn = new OleDbConnection(GetconnectstringLocal());
        objConn.Open();
        objCommand = new OleDbCommand(strSQL, objConn);
        objReader = objCommand.ExecuteReader();
        while (objReader.Read())
        {

            items.Add(objReader["firstname"].ToString());

        }
        objReader.Close(); objReader.Dispose(); objReader = null;
        objCommand.Dispose(); objCommand = null;
        objConn.Close(); objConn.Dispose(); objConn = null;
        return items.ToArray();
    }