protected void btnSubmit_Click(object sender, EventArgs e) { //Insert Kod Pencapaian Program const string sql = @"INSERT INTO PencapianProgram (KodProgram, TarikhProgram,BilanganHari,Lulus) VALUES (@KodProgram, @TarikhProgram,@BilanganHari,@Lulus) "; //get connection string from web.config var connection = ConfigurationManager.ConnectionStrings["Database"].ToString(); //buka connection using (var c = new SqlConnection(connection)) { var pencapaianProgram = new Entities.PencapianProgram { KodProgram = txtKodProgam.Text, TarikhProgram = DateTime.Parse(txtTkhProgram.Text), BilanganHari = int.Parse(txtBilHari.Text), Lulus = chckLulus.Checked }; c.Execute(sql, pencapaianProgram); } Response.Redirect("List.aspx"); }
protected void btnSubmit_Click(object sender, EventArgs e) { var id = Request.QueryString["Id"]; const string sql = @"UPDATE PencapianProgram SET KodProgram = @KodProgram, TarikhProgram = @TarikhProgram, BilanganHari = @BilanganHari, Lulus = @Lulus WHERE Id=@Id "; using (var c = ConnectionManager.getConnection()) { var pencapaian = new Entities.PencapianProgram { KodProgram = txtKodProgam.Text, TarikhProgram = DateTime.Parse(txtTkhProgram.Text), BilanganHari = int.Parse(txtBilHari.Text), Lulus = chckLulus.Checked, Id = int.Parse(id) }; c.Execute(sql, pencapaian); } }