紧随上个三层架构查询多个和单个
DAL
添加
public static int Insert(ClassInfo info)
{
var sql="insert into classinfo values(@name,@content)";
sqlparamete[] sqlparameter=new sqlparameter[]
{
new sqlparameter("@name",info.Name)
new sqlparameter("@content",info.Content)
};
return Class1.Nonquery(sql,sqlparameter);
}
删除
public static int Delete(int id)
{
var sql="delete from classinfo where id=@id";
sqlparameter[] sqlparameter=new sqlparameter[]
{
new sqlparameter("@id",id)
}；
return Class1.Nonquery(sql,sqlparameter);
}
BLL
添加
public static int Insert(ClassInfo info)
{
return ClassInfoDAL.Insert(info);
}
删除
public static int Delete(int id）
{
return ClassInfoDAL.Delete(id);
}
主项目 calssinfo.aspx
删除键
<asp:CommandField ShowDeleteButton="True" />
classinfo.aspx.cs 的GridView1_RowDeleting事件，双击
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var data = e.Values["Id"];
var id = Convert.ToInt32(data);
ClassInfoBLL.Delete(id);
if (ClassInfoBLL.Delete(id)>0)
{
var url = Request.Url.PathAndQuery;
Response.Redirect(url);
}
}