C#.NET - Jobba med databaser

Webbutveckling / C#.NET

Skriv till 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 write - 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("INSERT INTO people (firstname, lastname) VALUES ('John', 'Doe')");
sqlCmd.Connection = sqlConn;
sqlCmd.ExecuteNonQuery();

Response.Write("<p>Data inserted.</p>");

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

</body>
</html>