//1.OleDbConnection.ConnectinString:
//1).oracle--->"Provider=MSDAORA/OraOledb.Oracle; Data Source=ORACLE8i7;User ID=;Password=;"
//2).access--->"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/bin/LocalAccess40.mdb"
//3).sqlserver--->"Provider=SQLOLEDB;Data Source=MySQLServer;User ID=;Password=;"
// 4).sqlserver-->"Provider=sqloledb;database=mysqlserver;uid=pwd=;";
//常用连接数据字符串和例子
class ClassOleDb
{
private System.Data.OleDb.OleDbConnection _connection;
private System.Data.OleDb. OleDbCommand _commandCollection;
//private System.Data.OleDb.OleDbCommand[] _commandCollection;
private void InitConnection()
{
this._connection = new System.Data.OleDb.OleDbConnection();
this._connection.ConnectionString =global::MyExcel.Properties.Settings.Default.priceConnectionString;
_commandCollection = new OleDbCommand();
}
public ClassOleDb()
{
InitConnection();
}
/// <summary>
/// 输入序号返回价格
/// </summary>
/// <param name="jihao"></param>
/// <returns></returns>
public string selcet(string jihao)
{
string selectstr = "SELECT 价格 FROM jiage WHERE 序号 = '" + @jihao+"'";
_commandCollection.CommandText = selectstr;
_commandCollection.CommandType = CommandType.TableDirect;
_commandCollection.Connection= _connection;
_connection.Open();
OleDbDataReader reader = _commandCollection.ExecuteReader();
string returnvalue = "0";
if (reader.Read())
{
returnvalue = reader[0].ToString();
}
reader.Close();
_connection.Close();
return returnvalue;
}