C# OdbcConnection.Dispose方法代码示例

	static void Main ()
	{
		if (Environment.GetEnvironmentVariable ("MONO_TESTS_ODBC") == null)
			return;

		OdbcConnection conn = new OdbcConnection (CreateOdbcConnectionString ());
		conn.Open ();

		string dbName = Environment.GetEnvironmentVariable ("MONO_TESTS_SQL_DB");
		Assert.AreEqual (dbName, conn.Database, "#1");

		OdbcCommand cmd = new OdbcCommand ("CREATE DATABASE aфbиc", conn);
		cmd.ExecuteNonQuery ();
		cmd.Dispose ();

		try {
			Assert.AreEqual (dbName, conn.Database, "#2");
			conn.ChangeDatabase ("aфbиc");
			Assert.AreEqual ("aфbиc", conn.Database, "#3");
			conn.ChangeDatabase (dbName);
			Assert.AreEqual (dbName, conn.Database, "#4");
		} finally {
			conn.Dispose ();

			conn = new OdbcConnection (CreateOdbcConnectionString ());
			conn.Open ();

			cmd = new OdbcCommand ("DROP DATABASE aфbиc", conn);
			cmd.ExecuteNonQuery ();
			cmd.Dispose ();
		}
	}

        private void button1_Click(object sender, EventArgs e)
        {
 

            using(OdbcConnection oconn=new OdbcConnection(Basic_HTB_Info.Conn_Str)){
                oconn.Open();
                Form_Search_Res fsr = new Form_Search_Res();
                fsr.MdiParent = Basic_HTB_Info.cfg.MDIparent;
            if (textBox1.Text.Length > 0)
            {
                string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where stud_ref like '{0}' ", textBox1.Text);
                binding_btn(fsr, sql, oconn);
            }
            if (textBox2.Text.Length > 0)
            {
                string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where code like '{0}' ", textBox2.Text);
                binding_btn(fsr, sql, oconn);
            }
            if (textBox3.Text.Length > 0)
            {
                string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where name_c like '{0}' ", textBox3.Text);
                binding_btn(fsr, sql, oconn);
            }
            if (textBox4.Text.Length > 0)
            {
                String grade = textBox4.Text.Substring(0, textBox4.Text.Length - 1).ToUpper();
                String classno = textBox4.Text[textBox4.Text.Length - 1].ToString().ToUpper();
                string sql = String.Format("select stud_ref,name_c,name_p,grade,classno,c_no from student where grade='{0}' and classno='{1}' ", grade,classno);
                binding_btn(fsr, sql, oconn);
            }
                oconn.Close();
                oconn.Dispose();
                fsr.Show();
            }
        }

        public static string FetchTable(string SelectCommand, string XMLconnectionPhysicalFilePath, ref DataTable Dt)
        {
            OdbcConnection OdbcConn = new OdbcConnection();
            OdbcCommand OdbcCmd = new OdbcCommand();
            OdbcDataAdapter OdbcAdap = new OdbcDataAdapter();

            try
            {
                string DbErr = InitializeODBCConnection(ref OdbcConn, XMLconnectionPhysicalFilePath);

                if (DbErr == string.Empty)
                {
                    OdbcCmd.Connection = OdbcConn;
                    OdbcCmd.CommandText = SelectCommand;
                    OdbcAdap.SelectCommand = OdbcCmd;
                    OdbcAdap.Fill(Dt);
                    return string.Empty;
                }
                else
                    return DbErr;
            }
            catch (Exception err)
            {
                return err.Message;
            }
            finally
            { OdbcAdap.Dispose(); OdbcCmd.Dispose(); OdbcConn.Close(); OdbcConn.Dispose(); }
        }

        public static string GetDataTable(ref DataTable _ConnectionDt, ref DataTable ReturnDt, string SelectCommand)
        {
            OdbcConnection odbc_Conn = new OdbcConnection();
            OdbcDataAdapter odbcAdap = new OdbcDataAdapter();
            OdbcCommand odbcCmd = new OdbcCommand();

            string ErrMsg = string.Empty;

            try
            {
                ErrMsg = MakeInformixConnection(ref _ConnectionDt, ref odbc_Conn);

                if (ErrMsg == string.Empty)
                {
                        odbcCmd.Connection = odbc_Conn;
                        odbcCmd.CommandText = SelectCommand;
                        odbcAdap.SelectCommand = odbcCmd;
                        odbcAdap.Fill(ReturnDt);
                        odbc_Conn.Close();
                }
                return ErrMsg;
            }
            catch (Exception err)
            {
                return err.Message;
            }
            finally
            { odbcAdap.Dispose(); odbcCmd.Dispose(); odbc_Conn.Dispose(); }
        }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string constr = Session["connection"].ToString();
        OdbcConnection cn = new OdbcConnection(constr);
        cn.Open();
        string report_no = TextBox1.Text;
        string pol_no = DropDownList1.SelectedItem.ToString();
        string claim_date_1 = Calendar1.SelectedDate.ToString();
        string acc_date_1 = Calendar2.SelectedDate.ToString();
        string year1 = claim_date_1.Substring(6, 4);
        string month1 = claim_date_1.Substring(3, 2);
        string day1 = claim_date_1.Substring(0, 2);
        string claim_date = year1+ "-" + month1 + "-" + day1;
        string year2 = acc_date_1.Substring(6, 4);
        string month2 = acc_date_1.Substring(3, 2);
        string day2 = acc_date_1.Substring(0, 2);
        string acc_date = year2 + "-" + month2 + "-" + day2;
        string claim_amt = TextBox7.Text;
        string sql = "insert into CLAIM values ('" + report_no + "','" + claim_date_1 + "','" + acc_date_1 + "','" + claim_amt + "','" + pol_no+ "');";
        string sql2 = "select * from CLAIM where report_no = '" + report_no + "'";
        string sql3 = "select * from CLAIM where pol_no = '" + pol_no + "'";
        OdbcCommand cmd = new OdbcCommand(sql, cn);
        OdbcCommand cmd2 = new OdbcCommand(sql2, cn);
        OdbcCommand cmd3 = new OdbcCommand(sql3, cn);
        OdbcDataReader dr = cmd2.ExecuteReader();
        OdbcDataReader dr2 = cmd3.ExecuteReader();
        try
        {

            if (dr.HasRows == true)
            {

                Label1.Text = "Data with this Report No already exists";

            }
            else if (dr2.HasRows == true)
            {

                Label1.Text = "This Policy No has already been claimed";

            }
            else
            {
                cmd.ExecuteNonQuery();
                Label1.Text = "Data added successfully";
                Response.Redirect("HomePage.aspx");
            }
        }
        finally
        {
            dr.Close();
            dr2.Close();
            cn.Close();
            cn.Dispose();

        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string constr = Session["connection"].ToString();
        OdbcConnection cn = new OdbcConnection(constr);
        cn.Open();
        string fname = TextBox1.Text;
        string lname = TextBox10.Text;
        string c_id = TextBox2.Text;
        string c_sex = slist.SelectedItem.ToString();
        string dob_1 = Calendar1.SelectedDate.ToString();
        string year = dob_1.Substring(6, 4);
        string month = dob_1.Substring(3, 2);
        string day = dob_1.Substring(0, 2);
        string dob = year + "-" + month + "-" + day;
        string phoneno = TextBox11.Text;
        string address = TextBox4.Text;
        string a_id = TextBox9.Text;
        string n_name = TextBox5.Text;
        string n_sex = slist2.SelectedItem.ToString();
        string n_dob = Calendar2.SelectedDate.ToString();
        string relationship = TextBox8.Text;
        string sql = "insert into CUSTOMER values ('" + fname + "','" + lname + "','" + c_id + "','" + phoneno + "','" + c_sex + "','" + dob_1 + "','" + address + "','"+a_id+"');";
        string sql2 = "select * from CUSTOMER where cust_id = '" + c_id + "'";
        string sql3 = "insert into NOMINEE values ('" + n_name + "','" + n_sex + "','" + n_dob + "','" + relationship + "','" + c_id + "');";
        OdbcCommand cmd = new OdbcCommand(sql, cn);
        OdbcCommand cmd2 = new OdbcCommand(sql2, cn);
        OdbcCommand cmd3 = new OdbcCommand(sql3, cn);
        OdbcDataReader dr = cmd2.ExecuteReader();
        try
        {

            if (dr.HasRows == true)
            {

                Label1.Text = "Data with this Customer ID already exists";

            }
            else
            {
                cmd.ExecuteNonQuery();
                cmd3.ExecuteNonQuery();
                Label1.Text = "Data added successfully";
                Response.Redirect("HomePage.aspx");
            }
        }
        finally
        {
            dr.Close();
            cn.Close();
            cn.Dispose();

        }
    }

			public bool VerifyStudentId(string studentId)
			{
				var isValidId = false;
				var connection = new OdbcConnection { ConnectionString = "DSN=CARS" };

				var academicYear = GetAcademicYear();

				const string sql = "SELECT unique id_rec.id FROM id_rec, prog_enr_rec, outer stu_acad_rec " +
								   "WHERE id_rec.id = prog_enr_rec.id  " +
								   "AND id_rec.id = stu_acad_rec.id " +
								   "AND stu_acad_rec.yr in ('{0}','{1}') " +
								   "AND stu_acad_rec.reg_stat='C'  " +
								   "AND (stu_acad_rec.reg_hrs > 0 or stu_acad_rec.reg_au_hrs > 0) " +
								   "AND id_rec.id = '{2}'";

				var sqlToExecute = string.Format(sql, academicYear[0], academicYear[1], studentId);

				try
				{
					connection.Open();
					var command = connection.CreateCommand();

					command.CommandText = sqlToExecute;
					command.Connection = connection;
					var reader = command.ExecuteReader();
					reader.Read();
					isValidId = reader.HasRows;

					reader.Close();
					reader.Dispose();
				}
				catch (Exception ex)
				{
					// ReSharper disable once UnusedVariable
					var msg = ex.Message;
				}
				finally
				{
					connection.Close();
					connection.Dispose();
				}

				return isValidId;
			}

    protected void SubmitButton_Click1(object sender, EventArgs e)
    {
        string username = TextBoxUN.Text;
        string password = TextBoxPW.Text + TextBoxUN.Text;
        HashAlgorithm mhash = new SHA1CryptoServiceProvider();
        byte[] bytValue = System.Text.Encoding.UTF8.GetBytes(password);
        byte[] bytHash = mhash.ComputeHash(bytValue);
        mhash.Clear();
        password = Convert.ToBase64String(bytHash);

        string fullname = TextBoxFN.Text;
        string emailid = TextBoxEID.Text;

        String constr = Session["connection"].ToString();
        OdbcConnection cn = new OdbcConnection(constr);
        cn.Open();

        if (IsPostBack)
        {
            Response.Write("You have successfully completed registration");
            string sql = "insert into userdata values ('" + username + "','" + password + "','"+ fullname + "','"+emailid+"');";
            OdbcCommand cmd = new OdbcCommand(sql, cn);

            try
            {
                cmd.ExecuteNonQuery();
            }

            finally
            {
                cn.Close();
                cn.Dispose();

            }

            SubmitButton.Enabled = false;
            Response.Redirect("HomePage.aspx");

        }
    }

        public static object[,] GetAllData_mySQL(string MyConString, string sql)
        {
            OdbcConnection conn = new OdbcConnection(MyConString);
            conn.Open();

            OdbcCommand comm = new OdbcCommand(sql, conn);
            OdbcDataReader dr = comm.ExecuteReader();
            object[,] table = new object[dr.RecordsAffected+1, dr.FieldCount];

            object[] fields = new object[dr.FieldCount];
            int cc = 1;
            System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
            sw.Start();
            while (dr.Read())
            {
                dr.GetValues(fields);
                for (int i = 0; i < fields.Length; i++)
                {
                    table[0, i] = dr.GetName(i);
                    var t = fields[i].GetType();
                    if (t == typeof(double))
                        table[cc, i] = (double)fields[i];
                    else if (t == typeof(int))
                        table[cc, i] = (double)(int)fields[i];
                    else if (t == typeof(Int64))
                        table[cc, i] = (double)(Int64)fields[i];
                    else if (t == typeof(float))
                        table[cc, i] = (double)(float)fields[i];
                    else
                        table[cc, i] = fields[i].ToString();
                }
                cc = cc + 1;
            }
            System.Diagnostics.Debug.Print(sw.ElapsedMilliseconds.ToString());
            conn.Close();
            dr.Close();
            comm.Dispose();
            conn.Dispose();
            return table;
        }

        public MFCC_Manager()
        {
            OdbcConnection cn = new OdbcConnection(Global.Db2ConnectionString);
               OdbcCommand cmd = new OdbcCommand("select hostid,hostip,mfccid,mfcctype,remoteport from vwhostmfcc");

               OdbcDataReader rd;
               try
               {
               string hostid, hostip, mfccid, mfcctype;
               int remoteport;
               cn.Open();
               cmd.Connection = cn;
               rd = cmd.ExecuteReader();
               while (rd.Read())
               {
                   hostid = rd[0] as  string;
                   hostip = rd[1] as  string;
                   mfccid = rd[2] as string;
                   mfcctype = rd[3] as string;
                   remoteport = System.Convert.ToInt32(rd[4]);
                   ConsoleServer.WriteLine("begin load " + mfccid);
                   mfccs.Add(mfccid, new MFCC.MFCC_Object(hostid, hostip, remoteport,mfccid, mfcctype));
                   ConsoleServer.WriteLine("load mfcc:" + mfccid);
               }

               }
               catch (Exception ex)
               {
               ConsoleServer.WriteLine(ex.Message+ex.StackTrace);
               System.Environment.Exit(-1);
               }
               finally
               {
               cn.Close();
               cn.Dispose();
               }
        }

		bool isDbPrime(double in_num)
		{
			bool v_ret=false;

			//string strMdbFile="G:\\mathchallenge\\vbs\\Primes.mdb";
			//OleDbConnection oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdbFile);
			string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
				"SERVER=localhost;" +
				"DATABASE=Primes;" +
				"UID=primes;" +
				"OPTION=3";

			OdbcConnection odbcconn = new OdbcConnection(MyConString);
			OdbcCommand odbccom;
			OdbcDataReader odbcdr;
			string strsql="";
			strsql = "select PrimeNum from Primes where PrimeNum=" + in_num.ToString();
			odbcconn.Open();
			odbccom=new OdbcCommand(strsql,odbcconn);
			odbcdr = odbccom.ExecuteReader();

			v_ret=odbcdr.Read();

			odbcdr.Close();
			odbccom.Dispose();
			odbcconn.Close();
			odbcconn.Dispose();

			return v_ret;
		}

		void loadDivisors()
		{
			string MyConString = "dsn=sqlBulk;uid=bulkuser;";

			OdbcConnection odbcconn = new OdbcConnection(MyConString);
			OdbcCommand odbccom;
			string strsql = "select distinct Number from tblDivisors";
			odbcconn.Open();
			odbccom=new OdbcCommand(strsql,odbcconn);
			OdbcDataReader odbcdr= odbccom.ExecuteReader();
			int v_val=0;
			while(odbcdr.Read())
			{
				v_val=(int)odbcdr.GetInt32(0);
				if(!htctrl.ContainsKey(v_val))
				{
					htctrl.Add(v_val,v_val);
				}
			}
			odbcdr.Close();
			odbccom.Dispose();
			odbcconn.Close();
			odbcconn.Dispose();
		}

		void loadPrimes(int v_min,int v_max)
		{
			b_PrimesLoaded=true;
			//Hashtable v_ret=new Hashtable();
			//string strMdbFile="G:\\mathchallenge\\vbs\\Primes.mde";
			//OleDbConnection oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdbFile);
			string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
				"SERVER=localhost;" +
				"DATABASE=Primes;" +
				"UID=primes;" +
				"OPTION=3";

			OdbcConnection odbcconn = new OdbcConnection(MyConString);
			OdbcCommand odbccom;
			string strsql = "select distinct PrimeNum from Primes where PrimeNum between " + v_min.ToString() + " and " + v_max.ToString() + " order by PrimeNum";
			odbcconn.Open();
			odbccom=new OdbcCommand(strsql,odbcconn);
			OdbcDataReader odbcdr= odbccom.ExecuteReader();
			int v_val=0;
			while(odbcdr.Read())
			{
				v_val=(int)odbcdr.GetInt32(0);
				if(!htctrl.ContainsKey(v_val))
				{
					htctrl.Add(v_val,v_val);
				}
			}
			odbcdr.Close();
			odbccom.Dispose();
			odbcconn.Close();
			odbcconn.Dispose();
			//return v_ret;
		}

		public string getStartDiv()
		{
			string v_ret="0";
			string MyConString = "dsn=sqlBulk;uid=bulkuser;";

			OdbcConnection odbcconn = new OdbcConnection(MyConString);	
			
			string strsql = "select max(Number) from tblDivisors where number<5000000";
			odbcconn.Open();
			OdbcCommand odbccom=new OdbcCommand(strsql,odbcconn);
			
			try
			{
				OdbcDataReader odbcdr = odbccom.ExecuteReader();
				if(odbcdr.Read() && !odbcdr.IsDBNull(0))
				{
					v_ret = odbcdr.GetValue(0).ToString();
				}

			}
			catch
			{
				
			}
			odbccom.Dispose();
			odbcconn.Close();
			odbcconn.Dispose();

			return v_ret;
		}

 /// <summary>
 /// OdbcDb驱动 执行查询操作 x86平台
 /// </summary>
 /// <param name="p_strSql">查询sql语句</param>
 /// <param name="p_dicDictionary">字典参数</param>
 /// <param name="p_strTablename">产生的datatable名称</param>
 /// <param name="cmd">cmd</param>
 /// <returns>返回表</returns>
 static public DataTable OdbcExecuteBySQL(string p_strSql, Dictionary<string, string> p_dicDictionary, string p_strTablename)
 {
     //SetConnectionString();
     if ("" == m_strConnectionString)
     {
         MessageBox.Show("未设置数据库连接字符串！");
         return null;
     }
     DataTable _dtTable = new DataTable(p_strTablename);
     m_odbcConn = new OdbcConnection(m_strConnectionString);
     m_odbcCmd = m_odbcConn.CreateCommand();
     m_odbcConn.Open();
     OdbcChangeSelectCommand(p_strSql, p_dicDictionary, ref m_odbcCmd);
     try
     {
         using (OdbcDataAdapter adapter = new OdbcDataAdapter(m_odbcCmd))
         {
             adapter.Fill(_dtTable);
         }
     }
     catch (Exception exp)
     {
         WriteLog(exp, p_strSql);
     }
     finally
     {
         m_odbcConn.Dispose();
         m_odbcCmd.Dispose();
     }
     return _dtTable;
 }