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>