C#.NET - Jobba med databaser

Webbutveckling / C#.NET

Läs från MySQL-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.Odbc" %>

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

<%
OdbcConnection myConnection = new OdbcConnection(@"Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=db_name;User=root;Password=password_for_user_root;Socket=MySQL;Option=3;");
myConnection.Open();

Response.Write("<p>Connected to database test1</p>");

OdbcCommand sqlCmd = new OdbcCommand("SELECT firstname, lastname FROM people", myConnection);
OdbcDataReader myDataReader = sqlCmd.ExecuteReader();

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

Response.Write("<p>Query executed</p>");

myConnection.Close(); 
%>

</body>
</html>