取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)
来源:互联网 发布:软件信息服务业 规划 编辑:程序博客网 时间:2024/05/01 19:48
1.取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)
DatabaseSettings databaseSettings = ConfigurationManager.GetConfiguration("dataConfiguration") as DatabaseSettings;
string dataBase = this.generateRule_ddl_Database.SelectedValue;
if(databaseSettings.Instances[dataBase].DatabaseTypeName =="Sql Server")
{
ViewState["AlertRuleOorS"] = "0";
}
else
{
ViewState["AlertRuleOorS"] = "1";
}
string connectString = databaseSettings.Instances[dataBase].ConnectionString;
ConnectionStringData connectionStringData = databaseSettings.ConnectionStrings[connectString];
bool isPrimaryKey = false;
foreach( ParameterData parameter in connectionStringData.Parameters )
{
switch( parameter.Name.ToLower() )
{
case "database":
ViewState["database"] = parameter.Value;
break;
case "integrated security":
ViewState["Security"] = parameter.Value;
break;
case "server":
ViewState["server"] = parameter.Value;
break;
case "user id":
ViewState["userID"] = parameter.Value;
break;
case "password":
ViewState["password"] = parameter.Value;
break;
case "data source":
ViewState["dataSource"] = parameter.Value;
break;
}
}
DataConfiguration config;
if(ViewState["AlertRuleOorS"].ToString() == "0")
{
config = new DataConfiguration(DataBaseType.SqlServer ,ViewState["server"].ToString(),
ViewState["userID"].ToString() ,ViewState["password"].ToString() ,ViewState["database"].ToString() ,null);
}
else
{
config = new DataConfiguration(DataBaseType.Oracle,null,ViewState["userID"].ToString(),
ViewState["password"].ToString() ,null,ViewState["dataSource"].ToString());
}
IADOBase ado = ADOBaseFactory.CreateADOBase(config) ;
string table = "";
if(ViewState["generateRuleWay"] as string == "Script")
{
string[] sql = splitSQL(generateRule_txt_Rule.Text.ToString());
if(sql[1].IndexOf(',')!=-1)
{
LogicException le = new LogicException("MaintainAlert+BAS00057");
JscriptHelper.Alert(le);
}
table = sql[1].Trim();
}
else
{
table = this.generateRule_ddl_Table.SelectedValue.Trim();
}
DataSchema schema = ado.DataSchemaOperator.GetDataSchema(table);
StringBuilder primaryKey = new StringBuilder();
int count = schema.PKeyList.Count;
if(count != 0)
{
for(int n = 0;n<count;n++)
{
isPrimaryKey = true;
primaryKey.Append(schema.PKeyList[n]);
primaryKey.Append(",");
}
primaryKey.Remove(primaryKey.Length-1,1);
Session["primaryKey"] = primaryKey;
}
if(!isPrimaryKey)
{
LogicException le = new LogicException("MaintainAlert+BAS00054");
JscriptHelper.Alert(le);
this.generateRule_btn_PrimaryKey.Visible = true;
this.generateRule_lbl_PrimaryKey.Visible = true;
}
ViewState["check"] = "Y";
string dataBase = this.generateRule_ddl_Database.SelectedValue;
if(databaseSettings.Instances[dataBase].DatabaseTypeName =="Sql Server")
{
ViewState["AlertRuleOorS"] = "0";
}
else
{
ViewState["AlertRuleOorS"] = "1";
}
string connectString = databaseSettings.Instances[dataBase].ConnectionString;
ConnectionStringData connectionStringData = databaseSettings.ConnectionStrings[connectString];
bool isPrimaryKey = false;
foreach( ParameterData parameter in connectionStringData.Parameters )
{
switch( parameter.Name.ToLower() )
{
case "database":
ViewState["database"] = parameter.Value;
break;
case "integrated security":
ViewState["Security"] = parameter.Value;
break;
case "server":
ViewState["server"] = parameter.Value;
break;
case "user id":
ViewState["userID"] = parameter.Value;
break;
case "password":
ViewState["password"] = parameter.Value;
break;
case "data source":
ViewState["dataSource"] = parameter.Value;
break;
}
}
DataConfiguration config;
if(ViewState["AlertRuleOorS"].ToString() == "0")
{
config = new DataConfiguration(DataBaseType.SqlServer ,ViewState["server"].ToString(),
ViewState["userID"].ToString() ,ViewState["password"].ToString() ,ViewState["database"].ToString() ,null);
}
else
{
config = new DataConfiguration(DataBaseType.Oracle,null,ViewState["userID"].ToString(),
ViewState["password"].ToString() ,null,ViewState["dataSource"].ToString());
}
IADOBase ado = ADOBaseFactory.CreateADOBase(config) ;
string table = "";
if(ViewState["generateRuleWay"] as string == "Script")
{
string[] sql = splitSQL(generateRule_txt_Rule.Text.ToString());
if(sql[1].IndexOf(',')!=-1)
{
LogicException le = new LogicException("MaintainAlert+BAS00057");
JscriptHelper.Alert(le);
}
table = sql[1].Trim();
}
else
{
table = this.generateRule_ddl_Table.SelectedValue.Trim();
}
DataSchema schema = ado.DataSchemaOperator.GetDataSchema(table);
StringBuilder primaryKey = new StringBuilder();
int count = schema.PKeyList.Count;
if(count != 0)
{
for(int n = 0;n<count;n++)
{
isPrimaryKey = true;
primaryKey.Append(schema.PKeyList[n]);
primaryKey.Append(",");
}
primaryKey.Remove(primaryKey.Length-1,1);
Session["primaryKey"] = primaryKey;
}
if(!isPrimaryKey)
{
LogicException le = new LogicException("MaintainAlert+BAS00054");
JscriptHelper.Alert(le);
this.generateRule_btn_PrimaryKey.Visible = true;
this.generateRule_lbl_PrimaryKey.Visible = true;
}
ViewState["check"] = "Y";
2.dataConfiguration.config
<dataConfiguration>
<xmlSerializerSection type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data">
<enterpriseLibrary.databaseSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" defaultInstance="OracleDataAccess" xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
<databaseTypes>
<databaseType name="Oracle Database" type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
<databaseType name="Sql Server" type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data" />
</databaseTypes>
<instances>
<instance name="UserDataBase" type="Sql Server" connectionString="User Database Connection String" />
<instance name="BASDatabase" type="Sql Server" connectionString="BAS Database Connection String" />
<instance name="HMSDataBase" type="Sql Server" connectionString="HMS Connection String" />
<instance name="CBACDataBase" type="Sql Server" connectionString="CBAC Database Connection String" />
<instance name="OracleDataAccess" type="Oracle Database" connectionString="Oracle Database Connection String" />
</instances>
<connectionStrings>
<connectionString name="Oracle Database Connection String">
<parameters>
<parameter name="Data Source" value="ea21sg3t" isSensitive="false" />
<xmlSerializerSection type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data">
<enterpriseLibrary.databaseSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" defaultInstance="OracleDataAccess" xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
<databaseTypes>
<databaseType name="Oracle Database" type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
<databaseType name="Sql Server" type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data" />
</databaseTypes>
<instances>
<instance name="UserDataBase" type="Sql Server" connectionString="User Database Connection String" />
<instance name="BASDatabase" type="Sql Server" connectionString="BAS Database Connection String" />
<instance name="HMSDataBase" type="Sql Server" connectionString="HMS Connection String" />
<instance name="CBACDataBase" type="Sql Server" connectionString="CBAC Database Connection String" />
<instance name="OracleDataAccess" type="Oracle Database" connectionString="Oracle Database Connection String" />
</instances>
<connectionStrings>
<connectionString name="Oracle Database Connection String">
<parameters>
<parameter name="Data Source" value="ea21sg3t" isSensitive="false" />
<parameter name="user id" value="developer" isSensitive="false" />
<parameter name="password" value="developer" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="BAS Database Connection String">
<parameters>
<parameter name="database" value="BusinessAlert" isSensitive="false" />
<parameter name="password" value="sa" isSensitive="false" />
<parameter name="server" value="192.168.3.31" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="HMS Connection String">
<parameters>
<parameter name="database" value="HMS" isSensitive="false" />
<parameter name="Integrated Security" value="false" isSensitive="false" />
<parameter name="password" value="eptal" isSensitive="false" />
<parameter name="server" value="192.168.1.254" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="User Database Connection String">
<parameters>
<parameter name="database" value="master" isSensitive="false" />
<parameter name="password" value="sa" isSensitive="false" />
<parameter name="server" value="192.168.3.31" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="CBAC Database Connection String">
<parameters>
<parameter name="database" value="CBAC" isSensitive="false" />
<parameter name="password" value="eptal" isSensitive="false" />
<parameter name="server" value="192.168.1.254" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
<parameter name="password" value="developer" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="BAS Database Connection String">
<parameters>
<parameter name="database" value="BusinessAlert" isSensitive="false" />
<parameter name="password" value="sa" isSensitive="false" />
<parameter name="server" value="192.168.3.31" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="HMS Connection String">
<parameters>
<parameter name="database" value="HMS" isSensitive="false" />
<parameter name="Integrated Security" value="false" isSensitive="false" />
<parameter name="password" value="eptal" isSensitive="false" />
<parameter name="server" value="192.168.1.254" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="User Database Connection String">
<parameters>
<parameter name="database" value="master" isSensitive="false" />
<parameter name="password" value="sa" isSensitive="false" />
<parameter name="server" value="192.168.3.31" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
<connectionString name="CBAC Database Connection String">
<parameters>
<parameter name="database" value="CBAC" isSensitive="false" />
<parameter name="password" value="eptal" isSensitive="false" />
<parameter name="server" value="192.168.1.254" isSensitive="false" />
<parameter name="user id" value="sa" isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
- 取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)
- 查询数据库中表信息等
- 查询数据库中表使用的空间信息。
- 怎么取出数据库中表的数据生成XML文件
- 查询数据库中表中所有的字段名
- 用sql语句取出mysql 数据库中表的字段的说明信息
- 查询数据库里的数据
- python读取xml数据库中表内所有数据,获取数据库中所有表的字段名称
- 查询数据库中所有表的信息
- 查询数据库表的所有信息脚本
- 不知道数据库中表的列类型的前提下,使用JDBC正确的取出数据(取出Result结果集中的字段(不同类型))
- 可以获得Access数据库中表的信息
- 读取数据库中表和列的信息
- 查询数据库中表的数量及详细信息
- 查询数据库中表被锁的情况
- 查询数据库中表的大小情况。
- 数据库中表的复杂查询&分页
- Sql Server, 查询数据库中表的大小
- C#+Windows API操纵系统菜单
- 堆和栈的区别
- 和病毒战斗的日子(2)
- 空指针的利用
- 被恐怖分子抓去写程序...
- 取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)
- xiaoshen.exe详细信息(转)
- 小技巧集锦
- 17種正則表達式
- .Net 中无法正确显示中文问题
- 7939.com,7b.com.cn,9505.com,4199.com 清除工具(转)
- 分解SQL语句
- POWER6
- 35岁之前成功的12条黄金法则