@using System.Data.SqlClient;
@using System.Data;
//必須引用
<html>
<body>
<h1>Learn Sql</h1>
@{
string con = "Server=.;Database=Movies;Trusted_Connection=SSPI";
//.代表localhost，Datacase資料庫名稱，Trusted_Connection：選擇windows登陸資料庫時用此代替USER ID和PASSWORD。
string sql = "Select * from MoviesTable";
SqlConnection conn = new SqlConnection(con);
conn.Open();
//此時已連接配接上資料庫Movies
SqlDataAdapter SDA = new SqlDataAdapter(sql, con);
DataSet DS = new DataSet();
SDA.Fill(DS, "MoviesTable");
//DATASET用來擷取資料集，SQLCOMMAND用來操作資料庫（增删改查）
conn.Close();
//連結關閉後DATASET内容不消失
object[] row = DS.Tables[0].Rows[0].ItemArray;
}
<p>@row[1]</p>
</body>
</html> 引用： http://blog.csdn.net/kkkkkxiaofei/article/details/7904569
引用：http://www.cnblogs.com/bluestorm/p/3368466.html
![SQL優化SQL語句優化的目的[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)