20091024笔记

最新推荐文章于 2026-06-17 10:40:45 发布

原创最新推荐文章于 2026-06-17 10:40:45 发布 · 1.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#database #数据库 #server #sqlserver #scripting

技术专栏收录该内容

21 篇文章

订阅专栏

1、使用动软.net代码生成器连接数据库

动软的.net代码生成器连接数据库自动生成代码，节省了大量的程序员自己写代码的时间。连接数据库的类型很多，我之前连接过Mysql数据库，由于默认的是web开发的模式，所以如果使用winform的形式，需要自写主程序的配置文件。

1)连接MySql数据库的配置文件

<?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="BBKEDUSoftApp.Settings1" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
      <section name="BBKEDUForm.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
    </sectionGroup>
</configSections>
<connectionStrings>
    <add name="myWinFormConnectionString" connectionString="Data Source=myComputer/MS2008;Initial Catalog=test;Persist Security Info=True;User ID=my;Password=123456" providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
    <add key="ConnectionString" value="server=121.14.144.215;database=cwbbs;uid=geogerytony;pwd=geogerytony;oldsyntax=true;charset=utf8;" />
    <add key="DAL" value="BBKEDU.MySQLDAL" />
    <add key="ClientSettingsProvider.ServiceUri" value="" />
</appSettings>
<system.web>
    <membership defaultProvider="ClientAuthenticationMembershipProvider">
      <providers>
        <add name="ClientAuthenticationMembershipProvider" type="System.Web.ClientServices.Providers.ClientFormsAuthenticationMembershipProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" />
      </providers>
    </membership>
    <roleManager defaultProvider="ClientRoleProvider" enabled="true">
      <providers>
        <add name="ClientRoleProvider" type="System.Web.ClientServices.Providers.ClientRoleProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" cacheTimeout="86400" />
      </providers>
    </roleManager>
</system.web>
<userSettings>
    <BBKEDUSoftApp.Settings1>
      <setting name="PicPath" serializeAs="String">
        <value>/BBKEDUSoftApp/</value>
      </setting>
      <setting name="BBKEDUWeb" serializeAs="String">
        <value>http://icooyo.com/video/index.jsp?id=</value>
      </setting>
      <setting name="SOFTNAME" serializeAs="String">
        <value>步步高教育软件</value>
      </setting>
      <setting name="LoginNickandPwd" serializeAs="String">
        <value />
      </setting>
    </BBKEDUSoftApp.Settings1>
</userSettings>
</configuration>

2)连接sqlserver2000数据库的配置文件

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
    <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
      <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
        <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
        <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
          <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
          <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
          <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
          <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
        </sectionGroup>
      </sectionGroup>
    </sectionGroup>
</configSections>
<appSettings>
    
    <add key="ConStringEncrypt" value="false"/>
    
    <add key="ConnectionString" value="server=127.0.0.1;database=bbkcms_db;uid=sa;pwd=bbk2009"/>
    
    <add key="ConnectionStringAccounts" value="server=127.0.0.1;database=bbkcms_db;uid=sa;pwd=bbk2009"/>
    <add key="ConnectionString2" value="server=127.0.0.1;database=bbkcms_db;uid=sa;pwd=bbk2009"/>
    
    <add key="VirtualPath" value=""/>
    
    <add key="LoginPage" value="admin/Login.aspx"/>
    
    <add key="MenuExpanded" value="false"/>
    
    <add key="ModelCache" value="30"/>
</appSettings>
</configuration>