C#.NET - Jobba med databaser
Skriv info från formulär 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" %> <script runat="server"> void submit(Object s, EventArgs e){ SqlConnection sqlConn; 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(); string sqlQuery = "INSERT INTO people (firstname, lastname) VALUES ('" + firstName.Text + "', '" + lastName.Text + "')"; SqlCommand sqlCmd; sqlCmd = new SqlCommand(sqlQuery, sqlConn); sqlCmd.ExecuteNonQuery(); sqlConn.Close(); message.Text = "Data inserted"; firstName.Text = " "; lastName.Text = " "; } </script> <html> <head> <title>C#.NET</title> </head> <body> <form runat="server"> <asp:Label id="label1" runat="server" text="First name: "></asp:Label> <asp:TextBox id="firstName" runat="server"></asp:TextBox> <p> <asp:Label id="label2" runat="server" text="Last name: "></asp:Label> <asp:TextBox id="lastName" runat="server"></asp:TextBox> </p> <p> <asp:Button id="Button1" text="Submit" runat="server" OnClick="submit" /> </p> <p><asp:Label id="message" runat="server"></asp:Label></p> </form> </body> </html>