C#.NET - Jobba med databaser

Webbutveckling / C#.NET

Läs från MSSQL-databas

Spar exempelkoden nedan i en fil med filändelsen .aspx

Exempelkod:

<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
<head>
<title>MSSQL read - C#.NET</title>
</head>
<body>

<%
SqlDataReader dataReader;
SqlConnection sqlConn;
SqlCommand sqlCmd;
  
sqlConn = new SqlConnection(@"Data source=PCNAME\SQLEXPRESS;Initial Catalog=db_name;Integrated Security=SSPI;Persist Security Info=false;User ID=db_username;Password=;");
sqlConn.Open();

Response.Write("Connected to database test1");

sqlCmd = new SqlCommand("SELECT firstname, lastname FROM people");
sqlCmd.Connection = sqlConn;
dataReader = sqlCmd.ExecuteReader();

while (dataReader.Read()){
Response.Write("<p>");
Response.Write(dataReader.GetString(0));
Response.Write(" ");
Response.Write(dataReader.GetString(1));
Response.Write("</p>");
}

// Close the connection when done with it.
sqlConn.Close(); 
%>

</body>
</html>