@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