private void InitTable()
{
try
{
string strCommandText1 = "select name from MSysObjects where type=1 and flags=0";
accessHelper = new AccessHelper("Interference.mdb");
accessHelper.OpenConnection();
m_Table = accessHelper.ExecuteDataset(strCommandText1, null);
}
finally
{
accessHelper.CloseConnection();
}
}
/// <summary>
/// 从数据库读取速度信道字典
/// </summary>
public void GetChannelTypeInfo()
{
lock (m_Object)
{
string strCommondText = "select * from ChannelType";
//AccessHelper.DefineUserConnectionString("BUPT data.mdb");//定义北邮读的数据库
//DataTable tempDataTable = AccessHelper.ExecuteDataset(strCommondText,AccessType.UserDefine, null);
//华为要求所做的修改
AccessHelper accessHelper = new AccessHelper("BUPT data.mdb");
accessHelper.OpenConnection();
DataTable tempDataTable = accessHelper.ExecuteDataset(strCommondText, null);
accessHelper.CloseConnection();
InitialSpeedChannelDic(tempDataTable);
}
}
private void Init()
{
try
{
AccessHelper accessHelper = new AccessHelper("Interference.mdb");
accessHelper.OpenConnection();
foreach (DataRow row in m_Table.Rows)
{
string name = row[0].ToString();
string strCommandText = "SELECT * FROM " + name;
DataTable tempDataTable = accessHelper.ExecuteDataset(strCommandText, null);
m_TableDIC.Add(name, tempDataTable);
}
}
finally
{
accessHelper.CloseConnection();
}
}