相思资源网 Design By www.200059.com
.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>
相思资源网 Design By www.200059.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
相思资源网 Design By www.200059.com
暂无.net MVC 连接数据本地数据库三种方法总结的评论...