using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Configuration;
public partial class Add_Users : System.Web.UI.Page {
SqlConnection koneksi;
SqlCommand cmd;
protected void Page_Load(object sender, EventArgs e) {
}
protected void btnSave_Click(object sender, EventArgs e) {
insert();
}
public void insert() {
koneksi = new SqlConnection(ConfigurationManager.ConnectionStrings["koneksi_material"].ConnectionString);
koneksi.Open();
cmd = new SqlCommand("insert into t_users (username,password,email,level,namalengkap) values (@username,@password,@email,@level,@namalengkap)", koneksi);
cmd.Parameters.AddWithValue("@username", txtUsername.Text);
cmd.Parameters.AddWithValue("@password", txtPassword.Text);
cmd.Parameters.AddWithValue("@email", txtEmail.Text);
cmd.Parameters.AddWithValue("@level", cboLevel.Text);
cmd.Parameters.AddWithValue("@namalengkap", txtNamaLengkap.Text);
cmd.ExecuteNonQuery();
Response.Redirect("View_Users.aspx");
}
protected void btnCancel_Click(object sender, EventArgs e) {
Response.Redirect("View_Users.aspx");
}
}This code show how to insert data in ASP.Net.
