app.config

基于SQL SERVER 2005的SQL查询系统,利用SMO实现数据库的操作以及查询

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
        <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
            <section name="SqlQuery.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
        </sectionGroup>
        <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
            <section name="SqlQuery.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
        </sectionGroup>
    </configSections>
    <userSettings>
        <SqlQuery.Properties.Settings>
            <setting name="Query" serializeAs="String">
                <value>
/*
DSN=ScanXDSN;uid=sa;pwd=
Driver={SQL Server};Server=pc1123;Database=Vestfor;Uid=ScanX;Pwd=
Driver={SQL Server};Server=192.168.1.3;Database=ScanLicense;Uid=sa;Pwd=
Driver={SQL Server};Server=bridgetest;Database=ScanXNet;Uid=sa;Pwd=sa
DSN=TerminalLicense;uid=sa;pwd=

Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Language.DB;DefaultDir=U:\ScanX Projekt\ScanLan\;Dbq=U:\ScanX Projekt\ScanLan\;CollatingSequence=ASCII;
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=U:\ScanX Projekt\ScanLan\Language.DB;Extended Properties=Paradox 5.x;

Data Source=c:\ProgramData\Microsoft\eHome\EPG\d4961aeb7b4145a4b49b9e73e87eb9a2.sdf
*/
</value>
            </setting>
            <setting name="Connection" serializeAs="String">
                <value>DSN=ScanXDSN;Uid=sa;Pwd=</value>
            </setting>
            <setting name="Commit" serializeAs="String">
                <value>False</value>
            </setting>
            <setting name="SplitterDistance" serializeAs="String">
                <value>258</value>
            </setting>
            <setting name="FormWindowsState" serializeAs="String">
                <value>Normal</value>
            </setting>
            <setting name="FormClientSize" serializeAs="String">
                <value>512, 455</value>
            </setting>
            <setting name="FormLocation" serializeAs="String">
                <value>0, 0</value>
            </setting>
            <setting name="MaxRecords" serializeAs="String">
                <value>True</value>
            </setting>
            <setting name="DBDriver" serializeAs="String">
                <value />
            </setting>
        </SqlQuery.Properties.Settings>
    </userSettings>
    <applicationSettings>
        <SqlQuery.Properties.Settings>
            <setting name="ValidColumnNameChars" serializeAs="String">
                <value>ABCDEFGHIJKLMNOPQRSTUVWXYZ脝脴脜abcdefghijklmnopqrstuvwxyz忙酶氓_</value>
            </setting>
            <setting name="MaxRecordCount" serializeAs="String">
                <value>100</value>
            </setting>
        </SqlQuery.Properties.Settings>
    </applicationSettings>
</configuration>