当前位置： 移动技术网 > IT编程>开发语言>.net > .net MVC 连接数据本地数据库三种方法总结

.net MVC 连接数据本地数据库三种方法总结

2017年12月12日  | 移动技术网IT编程  | 我要评论

格调网主题,龙骨壮骨颗粒,南方寝室官网

.net mvc 连接数据本地数据库三种方法

  <appsettings>
   <add key="webpages:version" value="2.0.0.0" />
   <add key="webpages:enabled" value="false" />
   <add key="preserveloginurl" value="true" />
   <add key="clientvalidationenabled" value="true" />
   <add key="unobtrusivejavascriptenabled" value="true" />
   <add key="con" value="server=.\sqlexpress; user id = sa;password = a123456;database = xsgl1;max pool size=512;"/>
  </appsettings>
  <connectionstrings>
   <add name="consql" connectionstring="server=(local)\sqlexpress; user id = sa;password = a123456;database = xsgl1;max pool size=512;"/>
  </connectionstrings> 

configuration
  public class homecontroller : controller
   {
     //
     // get: /home/
 
     public actionresult index()
     {
       #region connect sql function one
       sqlconnectionstringbuilder one = new sqlconnectionstringbuilder();
       one.datasource = "(local)\\sqlexpress";
      one.initialcatalog = "xsgl1";
       one.userid = "sa";
       one.password = "a123456";
       one.maxpoolsize = 512;
       sqlconnection sct = new sqlconnection(one.connectionstring);
       #endregion
       #region connect sql function two
       //string conn = configurationmanager.appsettings["con"].tostring();
       //sqlconnection sct = new sqlconnection(conn);
       #endregion
       #region connect sql function three
       //string conn = configurationmanager.connectionstrings["consql"].connectionstring;
       //sqlconnection sct = new sqlconnection(conn);
       #endregion
       sqlcommand scm = new sqlcommand();
       scm.connection = sct;
      scm.commandtype = commandtype.text;
       scm.commandtext = "select 课程名 from kc where 课程号='a001'";
       sct.open();
       sqldatareader sdr = scm.executereader();
       if (sdr.read())
       {
        viewbag.hao = sdr["课程名"];
      }
      sdr.close();
      return view();
    }
    public actionresult about()
    {
      return view();
     }
   }

controller
@{
  viewbag.title = "index";
 }
 @viewbag.hao
 <h2>index</h2>

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网