@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.htmlC # ASP. NET RAZOR linked SQL Server