<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>