8,497
社区成员
发帖
与我相关
我的任务
分享
protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
using (var dc = new myDataClassesDataContext())
{
//先删除从表数据、再删除主表数据
dc.ExecuteCommand("delete from MessageTable where MessageID=" + e.CommandArgument.ToString());
this.GridView1.DataBind();
}
}
}
protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e)
{
try
{
using (var db = new myDataClassesDataContext())
{
var name = GridView1.Rows[e.RowIndex].Cells[0].Text;
var del = from o in db.MessageTable
where o.MessageID == int.Parse(name)
select o;
foreach (var d in del)
{
db.MessageTable.DeleteOnSubmit(d);
db.SubmitChanges();
this.GridView1.DataBind();
}
getdata();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
}
# 创建insert类型触发器
--创建insert插入类型触发器
if (object_id('tgr_classes_insert', 'tr') is not null)
drop trigger tgr_classes_insert
go
create trigger tgr_classes_insert
on classes
for insert --插入触发
as
--定义变量
declare @id int, @name varchar(20), @temp int;
--在inserted表中查询已经插入记录信息
select @id = id, @name = name from inserted;
set @name = @name + convert(varchar, @id);
set @temp = @id / 2;
insert into student values(@name, 18 + @id, @temp, @id);
print '添加学生成功!';
go
--插入数据
insert into classes values('5班', getDate());
--查询数据
select * from classes;
select * from student order by id;
insert触发器,会在inserted表中添加一条刚插入的记录。