.net MVC 连接数据本地数据库三种方法总结
.netMVC连接数据本地数据库三种方法
<appSettings> <addkey="webpages:Version"value="2.0.0.0"/> <addkey="webpages:Enabled"value="false"/> <addkey="PreserveLoginUrl"value="true"/> <addkey="ClientValidationEnabled"value="true"/> <addkey="UnobtrusiveJavaScriptEnabled"value="true"/> <addkey="con"value="server=.\sqlexpress;userid=sa;password=a123456;database=xsgl1;maxpoolsize=512;"/> </appSettings> <connectionStrings> <addname="conSql"connectionString="server=(local)\sqlexpress;UserId=sa;password=a123456;database=xsgl1;maxpoolsize=512;"/> </connectionStrings> Configuration
publicclassHomeController:Controller
{
//
//GET:/Home/
publicActionResultIndex()
{
#regionconnectsqlfunctionone
SqlConnectionStringBuilderone=newSqlConnectionStringBuilder();
one.DataSource="(local)\\sqlexpress";
one.InitialCatalog="xsgl1";
one.UserID="sa";
one.Password="a123456";
one.MaxPoolSize=512;
SqlConnectionsct=newSqlConnection(one.ConnectionString);
#endregion
#regionconnectsqlfunctiontwo
//stringconn=ConfigurationManager.AppSettings["con"].ToString();
//SqlConnectionsct=newSqlConnection(conn);
#endregion
#regionconnectsqlfunctionthree
//stringconn=ConfigurationManager.ConnectionStrings["conSql"].ConnectionString;
//SqlConnectionsct=newSqlConnection(conn);
#endregion
SqlCommandscm=newSqlCommand();
scm.Connection=sct;
scm.CommandType=CommandType.Text;
scm.CommandText="select课程名fromkcwhere课程号='A001'";
sct.Open();
SqlDataReadersdr=scm.ExecuteReader();
if(sdr.Read())
{
ViewBag.hao=sdr["课程名"];
}
sdr.Close();
returnView();
}
publicActionResultAbout()
{
returnView();
}
}
Controller
@{
ViewBag.Title="Index";
}
@ViewBag.hao
<h2>Index</h2>热门推荐
10 财运虎年祝福语简短语
11 单亲爸爸春节祝福语简短
12 狗狗上厕所训练
13 植物种植祝福语简短
14 翻译考试祝福语朋友简短
15 个人周年庆简短祝福语
16 狗狗怎么训练
17 分别祝福语简短搞笑英文
18 生日广州男生祝福语简短