本文整理汇总了C#中System.Data.Odbc.OdbcConnection.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# OdbcConnection.Dispose方法的具体用法?C# OdbcConnection.Dispose怎么用?C# OdbcConnection.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Odbc.OdbcConnection
的用法示例。
在下文中一共展示了OdbcConnection.Dispose方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
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 ();
}
}
示例2: button1_Click
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();
}
}
示例3: FetchTable
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(); }
}
示例4: GetDataTable
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(); }
}
示例5: Button1_Click
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();
}
}
示例6: Button1_Click
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();
}
}
示例7: VerifyStudentId
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;
}
示例8: SubmitButton_Click1
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");
}
}
示例9: GetAllData_mySQL
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;
}
示例10: MFCC_Manager
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();
}
}
示例11: isDbPrime
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;
}
示例12: loadDivisors
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();
}
示例13: loadPrimes
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;
}
示例14: getStartDiv
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;
}
示例15: OdbcExecuteBySQL
/// <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;
}