C # ASP. NET RAZOR linked SQL Server

@using System.Data.SqlClient; @using System.Data;
Must reference    @{        stringCon ="server=.;D Atabase=movies; Trusted_connection=sspi";
. Represents the Localhost,datacase database name,trusted_connection: Use this instead of the user ID and password when selecting Windows to log in to the database. stringsql ="Select * from Moviestable"; SqlConnection Conn=NewSqlConnection (con); Conn. Open ();
The database is now connected movies SqlDataAdapter SDA=NewSqlDataAdapter (sql, con); DataSet DS=NewDataSet (); Sda. Fill (DS,"moviestable");
The dataset is used to obtain the data set, and SqlCommand is used to manipulate the database (add and revise) Conn. Close ();
DataSet content does not disappear after link is closedObject[] row = DS. tables[0]. rows[0].    ItemArray; }    <p> @row [1]</p></body>
Reference: http://blog.csdn.net/kkkkkxiaofei/article/details/7904569Reference: http://www.cnblogs.com/bluestorm/p/3368466.html
C # ASP. NET RAZOR linked SQL Server