protected void Page_Load(object sender, EventArgs e) { string id=Session["id"].ToString(); string name = Session["name"].ToString(); // Response.Write(id+ " " +name); } protected void btnsave_Click(object sender, EventArgs e) { string con = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; SqlConnection conn = new SqlConnection(); conn.ConnectionString = con; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "insert into tblstudentinfo(studentname, fathername) values('"+txtstdname.Text+"', '"+txtfthername.Text+"')"; cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); }
create trigger instblstudentinfo on tblstudentinfo for insert as begin declare @id int; declare @changes varchar(100); select @id=i.id from selected i; set @changes='Record Inserted'; insert into tblstudentinfo_audit(id, changes) values(@id, @changes) end
insert into tblstudentinfo_audit(id, changes) select id, @changes from inserted
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)