.net MVC 連接數據本地資料庫三種方法

 1  1   <appSettings>
 2  2     <add key="webpages:Version" value="2.0.0.0" />
 3  3     <add key="webpages:Enabled" value="false" />
 4  4     <add key="PreserveLoginUrl" value="true" />
 5  5     <add key="ClientValidationEnabled" value="true" />
 6  6     <add key="UnobtrusiveJavaScriptEnabled" value="true" />
 7  7     <add key="con" value="server=.\sqlexpress; user id = sa;password = a123456;database = xsgl1;max pool size=512;"/>
 8  8   </appSettings>
 9  9   <connectionStrings>
10 10     <add name="conSql" connectionString="server=(local)\sqlexpress; User Id = sa;password = a123456;database = xsgl1;max pool size=512;"/>
11 11   </connectionStrings> 

 1 1     public class HomeController : Controller
 2  2     {
 3  3         //
 4  4         // GET: /Home/
 5  5 
 6  6         public ActionResult Index()
 7  7         {
 8  8             #region connect sql function one
 9  9             SqlConnectionStringBuilder one = new SqlConnectionStringBuilder();
10 10             one.DataSource = "(local)\\sqlexpress";
11 11             one.InitialCatalog = "xsgl1";
12 12             one.UserID = "sa";
13 13             one.Password = "a123456";
14 14             one.MaxPoolSize = 512;
15 15             SqlConnection sct = new SqlConnection(one.ConnectionString);
16 16             #endregion
17 17             #region connect sql function two
18 18             //string conn = ConfigurationManager.AppSettings["con"].ToString();
19 19             //SqlConnection sct = new SqlConnection(conn);
20 20             #endregion
21 21             #region connect sql function three
22 22             //string conn = ConfigurationManager.ConnectionStrings["conSql"].ConnectionString;
23 23             //SqlConnection sct = new SqlConnection(conn);
24 24             #endregion
25 25             SqlCommand scm = new SqlCommand();
26 26             scm.Connection = sct;
27 27             scm.CommandType = CommandType.Text;
28 28             scm.CommandText = "select 課程名 from kc where 課程號='A001'";
29 29             sct.Open();
30 30             SqlDataReader sdr = scm.ExecuteReader();
31 31             if (sdr.Read())
32 32             {
33 33                 ViewBag.hao = sdr["課程名"];
34 34             }
35 35             sdr.Close();
36 36             return View();
37 37         }
38 38         public ActionResult About()
39 39         {
40 40             return View();
41 41         }
42 42     }

1 1 @{
2 2     ViewBag.Title = "Index";
3 3 }
4 4 @ViewBag.hao
5 5 <h2>Index</h2>