本文整理汇总了C#中System.Data.Odbc.OdbcConnection.Open方法的典型用法代码示例。如果您正苦于以下问题:C# OdbcConnection.Open方法的具体用法?C# OdbcConnection.Open怎么用?C# OdbcConnection.Open使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Odbc.OdbcConnection
的用法示例。
在下文中一共展示了OdbcConnection.Open方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BLbusiness
//luodaan uusi bisnes
public BLbusiness(string name, string katuosoite, string postinro, string kaupunki, OdbcConnection conn)
{
//business address
this.address = new BLaddress(conn, katuosoite, postinro, kaupunki);
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO business (BusinessName, Address_AddressId) VALUES (?, ?)";
insertcmd.Parameters.Add("@BusinessName", OdbcType.VarChar, 100).Value = name;
insertcmd.Parameters.Add("@Address_AddressId", OdbcType.Int).Value = this.address.id;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT BusinessId, BusinessName FROM business WHERE BusinessName = ?";
cmd.Parameters.Add("@BusinessName", OdbcType.VarChar, 100).Value = name;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例2: GetOpenConnection
public static DbConnection GetOpenConnection(AdoProviderType providerType, string connStr, int retryCount, int retryDelay)
{
DbConnection conn = null;
switch (providerType)
{
case AdoProviderType.SqlProvider:
conn = new SqlConnection(connStr);
break;
case AdoProviderType.OleProvider:
conn = new OleDbConnection(connStr);
break;
case AdoProviderType.OdbcProvider:
conn = new OdbcConnection(connStr);
break;
default:
throw new Exception("This provider type is not supported.");
}
if (conn != null)
{
conn.Open();
int attemptCount = 0;
while (conn.State!=ConnectionState.Open && ++attemptCount < retryCount)
{
System.Threading.Thread.Sleep(retryDelay);
conn.Open();
}
if (conn.State != ConnectionState.Open)
throw new Exception("Unable to open connection using specified connection string.");
}
return conn;
}
示例3: BLfeedback
//constructor
public BLfeedback(int customerid, int servicepackageid, OdbcConnection conn)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO feedback (Customer_CustomerId, Timestamp, ServicePackage_ServicePackageId) VALUES (?,?,?)";
insertcmd.Parameters.Add("@Customer_CustomerId", OdbcType.Int).Value = customerid;
this.timestamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
insertcmd.Parameters.Add("@Timestamp", OdbcType.VarChar, 20).Value = this.timestamp;
insertcmd.Parameters.Add("@Customer_CustomerId", OdbcType.Int).Value = servicepackageid;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT FeedbackId, Customer_CustomerId, Timestamp, ServicePackage_ServicePackageId FROM feedback WHERE Customer_CustomerId = ? AND Timestamp = ? AND ServicePackage_ServicePackageId = ?";
cmd.Parameters.Add("@Customer_CustomerId", OdbcType.Int).Value = customerid;
cmd.Parameters.Add("@Timestamp", OdbcType.VarChar, 20).Value = this.timestamp;
cmd.Parameters.Add("@Customer_CustomerId", OdbcType.Int).Value = servicepackageid;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
int id2;
int.TryParse(rows.GetString(1), out id2);
this.customerid = id2;
this.timestamp = rows.GetString(2);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例4: BLcustomer
//constructor
public BLcustomer(string name, string phonenumber, string email, OdbcConnection conn)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO customer (CustomerName, PhoneNro, Email) VALUES (?, ?, ?)";
insertcmd.Parameters.Add("@CustomerName", OdbcType.VarChar, 100).Value = name;
insertcmd.Parameters.Add("@PhoneNro", OdbcType.VarChar, 10).Value = phonenumber;
insertcmd.Parameters.Add("@Email", OdbcType.VarChar, 100).Value = email;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT CustomerId, CustomerName, PhoneNro, Email FROM customer WHERE CustomerName = ? AND PhoneNro = ? AND Email = ?";
cmd.Parameters.Add("@CustomerName", OdbcType.VarChar, 100).Value = name;
cmd.Parameters.Add("@PhoneNro", OdbcType.VarChar, 10).Value = phonenumber;
cmd.Parameters.Add("@Email", OdbcType.VarChar, 100).Value = email;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
this.phonenumber = rows.GetString(2);
this.email = rows.GetString(3);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例5: BLcomment
//constructor
public BLcomment(string name, int feedbackid, OdbcConnection conn)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO comment (Text, Feedback_FeedbackId) VALUES (?, ?)";
insertcmd.Parameters.Add("@Text", OdbcType.VarChar, 1024).Value = name;
insertcmd.Parameters.Add("@Feedback_FeedbackId", OdbcType.Int).Value = feedbackid;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT CommentId, Text, Feedback_FeedbackId FROM comment WHERE Text = ? AND Feedback_FeedbackId = ?";
cmd.Parameters.Add("@Text", OdbcType.VarChar, 1024).Value = name;
cmd.Parameters.Add("@Feedback_FeedbackId", OdbcType.Int).Value = feedbackid;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
int id2;
int.TryParse(rows.GetString(2), out id2);
this.feedbackid = id2;
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例6: BLaddress
//constructor
public BLaddress(OdbcConnection conn, string katuosoite, string postinro, string kaupunki)
{
//constructing attributes
this.city = new BLcity(conn, kaupunki);
this.zipcode = new BLzipcode(conn, postinro);
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO address (City_CityId, ZIPCode_ZIPCodeId, StreetAddress) VALUES (?, ?, ?)";
insertcmd.Parameters.Add("@City_CityId", OdbcType.Int).Value = this.city.id;
insertcmd.Parameters.Add("@ZIPCode_ZIPCodeId", OdbcType.Int).Value = this.zipcode.id;
insertcmd.Parameters.Add("@StreetAddress", OdbcType.VarChar, 50).Value = katuosoite;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT AddressId, StreetAddress FROM address WHERE StreetAddress = ?";
cmd.Parameters.Add("@ZIPCodeNumber", OdbcType.VarChar, 50).Value = katuosoite;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
}
catch (Exception ex)
{
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例7: BLservicepackage
public BLservicepackage(string name, int service, OdbcConnection conn)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO servicepackage (ServicePackageName, Service_ServiceId) VALUES (?, ?)";
insertcmd.Parameters.Add("@ServicePackageName", OdbcType.VarChar, 100).Value = name;
insertcmd.Parameters.Add("@Service_ServiceId", OdbcType.Int).Value = service;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT ServicePackageId, ServicePackageName FROM servicepackage WHERE ServicePackageName = ?";
cmd.Parameters.Add("@ServicePackageName", OdbcType.VarChar, 100).Value = name;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例8: BLzipcode
//constructor
public BLzipcode(OdbcConnection conn, string postinro)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO zipcode (ZIPCodeNumber) VALUES (?)";
insertcmd.Parameters.Add("@ZIPCodeNumber", OdbcType.VarChar, 5).Value = postinro;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT ZIPCodeId, ZIPCodeNumber FROM zipcode WHERE ZIPCodeNumber = ?";
cmd.Parameters.Add("@ZIPCodeNumber", OdbcType.VarChar, 5).Value = postinro;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select kaikissa osoite BL:ssä sama*/
}
示例9: BLcity
//constructor
public BLcity(OdbcConnection conn, string kaupunki)
{
/*start copy pasta insert/select same in all BL files*/
try
{
//parameterized queries
conn.Open();
OdbcCommand insertcmd = conn.CreateCommand();
insertcmd.CommandText = "INSERT IGNORE INTO city (CityName) VALUES (?)";
insertcmd.Parameters.Add("@CityName", OdbcType.VarChar, 20).Value = kaupunki;
insertcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
try
{
//parameterized queries
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT CityId, CityName FROM city WHERE CityName = ?";
cmd.Parameters.Add("@CityName", OdbcType.VarChar, 20).Value = kaupunki;
OdbcDataReader rows = cmd.ExecuteReader();
rows.Read();
int id;
int.TryParse(rows.GetString(0), out id);
this.id = id;
this.name = rows.GetString(1);
}
catch (Exception ex)
{
this.id = -1;
this.name = ex.ToString();
conn.Close();
return;
}
finally
{
conn.Close();
}
/*end copy pasta insert/select same in all BL files*/
}
示例10: addUser
private String addUser()
{
try
{
Contract contract = new Contract();
String cxnString = "Driver={SQL Server};Server=HC-sql7;Database=REVINT;Trusted_Connection=yes;";
using (OdbcConnection dbConnection = new OdbcConnection(cxnString))
{
//open OdbcConnection object
dbConnection.Open();
OdbcCommand cmd = new OdbcCommand();
cmd.CommandText = "{CALL [REVINT]." + contract.getSchema() + ".[OCP_addUser]( ?, ?, ?, ? )}";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = dbConnection;
cmd.Parameters.Add("@hawkId", OdbcType.NVarChar, 400).Value = txtHealthcareID.Text;
cmd.Parameters.Add("@administrator", OdbcType.Bit).Value = chkAdmin.IsChecked;
cmd.Parameters.Add("@name", OdbcType.NVarChar, 400).Value = txtName.Text;
cmd.Parameters.Add("@numRecords", OdbcType.Int);
cmd.Parameters["@numRecords"].Direction = System.Data.ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
dbConnection.Close();
return cmd.Parameters["@numRecords"].Value.ToString();
}
}
catch (Exception)
{
return null;
}
}
示例11: Main
static void Main(string[] args)
{
//"DRIVER={MySQL ODBC 5.2w Driver};SERVER=localhost;DATABASE=config;UID=root;PASSWORD=liu355dq;"
string MyConString = "DRIVER={MySQL ODBC 5.2w Driver};" +
"SERVER=localhost;" +
"DATABASE=g_db;" +
"UID=root;" +
"PASSWORD=liu355dq;";
OdbcConnection myconnection = new OdbcConnection(MyConString);
OdbcCommand cmd = new OdbcCommand("select * from g_operator");
cmd.Connection = myconnection;
myconnection.Open();
OdbcDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[1]);
}
myconnection.Close();
Console.ReadKey();
}
示例12: ObtenerConexion
public static OdbcConnection ObtenerConexion()
{
mySqlConeccion = new OdbcConnection("Driver={MySQL ODBC 5.3 ANSI Driver};Server=localhost;Database=colchoneria;User=root;Password=; Option=3;");
mySqlConeccion.Open();
return mySqlConeccion;
}
示例13: GetAccountExists
// Check esistenza account
public bool GetAccountExists(String username, out String error)
{
bool exists = false;
error = "";
try
{
// Connesione db
OdbcConnection odbc = new OdbcConnection("DSN=nwn_master_server");
odbc.Open();
using (OdbcCommand dbcmd = odbc.CreateCommand()) {
// Query
String query = "SELECT username FROM " + TABLE_ACCOUNTS + " WHERE username='" + username + "'";
dbcmd.CommandText = query;
using (OdbcDataReader dbreader = dbcmd.ExecuteReader()) {
while(dbreader.Read()){
if ((String)dbreader["username"] == username)
exists = true;
}
dbreader.Close();
}
}
odbc.Close();
}
catch (Exception e) {
error = e.StackTrace;
}
// Exit
return exists;
}
示例14: getPredictionWS
public string getPredictionWS(string currency_name)
{
string connString = "DSN=MySQLODBC;UID=root;PWD=admin";
OdbcConnection conn = new OdbcConnection(connString);
OdbcCommand comm = new OdbcCommand();
comm.Connection = conn;
comm.CommandTimeout = 300;
comm.CommandText = "select CurrencyID from currency where CurrencyName = '" + currency_name + "'";
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow row = ds.Tables[0].Rows[0];
string currency_id = row[0].ToString();
comm.CommandText = "select predictsignal,predictprice,recognitionrate from currencyprediction where CurrencyID = " + currency_id + "";
OdbcDataAdapter da1 = new OdbcDataAdapter(comm);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
string predictionarray;
predictionarray = ds1.Tables[0].Rows[0].ItemArray[0] + "," + ds1.Tables[0].Rows[0].ItemArray[1] + "," + ds1.Tables[0].Rows[0].ItemArray[2];
return predictionarray;
}
示例15: getQuotesWS
public string getQuotesWS(string currency_name)
{
string connString = "DSN=MySQLODBC;UID=root;PWD=admin";
OdbcConnection conn = new OdbcConnection(connString);
OdbcCommand comm = new OdbcCommand();
comm.Connection = conn;
comm.CommandText = "select CurrencyID from currency where CurrencyName = '" + currency_name + "'";
conn.Open();
OdbcDataAdapter da = new OdbcDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow row = ds.Tables[0].Rows[0];
string currency_id = row[0].ToString();
comm.CommandText = "select currentprice from currencyprediction where CurrencyID = " + currency_id + "";
OdbcDataAdapter da1 = new OdbcDataAdapter(comm);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
DataRow row1 = ds1.Tables[0].Rows[0];
string currentQuotePrice = row1[0].ToString();
return currentQuotePrice;
}