C#.NET - Jobba med databaser
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>