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);
}
}
