public PeptideDAL(string sDataBase)
{
string sServer = System.Configuration.ConfigurationManager.AppSettings["DataBaseServer"].ToString();
string sUid = System.Configuration.ConfigurationManager.AppSettings["DataBaseUid"].ToString();
string sPwd = System.Configuration.ConfigurationManager.AppSettings["DataBasePwd"].ToString();
string sMySqlConnString = string.Format("Server={0};Database={1};Uid={2};Pwd={3};Persist Security Info=True;Pooling=False;", sServer, sDataBase, sUid, sPwd);
sqlHelper = new SQLHelper(sMySqlConnString);
lstColName.Add("ID");
lstColName.Add("AC");
lstColName.Add("DT");
lstColName.Add("DE");
lstColName.Add("GN");
lstColName.Add("OS");
lstColName.Add("OC");
lstColName.Add("OX");
lstColName.Add("RN");
lstColName.Add("RP");
lstColName.Add("RX");
lstColName.Add("RA");
lstColName.Add("RT");
lstColName.Add("RL");
lstColName.Add("RC");
lstColName.Add("RG");
lstColName.Add("CC");
lstColName.Add("DR");
lstColName.Add("PE");
lstColName.Add("KW");
lstColName.Add("FT");
lstColName.Add("SQ");
lstColName.Add("ModResSingle");
}
public PeptideModResDAL(string sDataBase)
{
string sServer = System.Configuration.ConfigurationManager.AppSettings["DataBaseServer"].ToString();
string sUid = System.Configuration.ConfigurationManager.AppSettings["DataBaseUid"].ToString();
string sPwd = System.Configuration.ConfigurationManager.AppSettings["DataBasePwd"].ToString();
string sMySqlConnString = string.Format("Server={0};Database={1};Uid={2};Pwd={3};Persist Security Info=True;Pooling=False;", sServer, sDataBase, sUid, sPwd);
sqlHelper = new SQLHelper(sMySqlConnString);
}