一、try { 执行语句 } catch(Exception e) { return false; }
在Edit.aspx页面的点击事件时要判断变量action的值,用到插入和更新数据库的函数为bool型,
public bool add(News_Type type)
{
string sql="insert into NewsType(NewsTypeName,NewsTypeDepth,AddTime) values (";
sql += "'" + type.NewsTypeName + "'," + type.NewsTypeDepth + ",'" + type.AddTime + "',)" ;
sql += "'" + type.NewsTypeName + "'," + type.NewsTypeDepth + ",'" + type.AddTime + "',)" ;
try
{
DbManage.getDbManage().ExecuteNoSql(sql);
}
catch (Exception e) //注意Exception的E大写
{
return false;
}
return true;
{
DbManage.getDbManage().ExecuteNoSql(sql);
}
catch (Exception e) //注意Exception的E大写
{
return false;
}
return true;
}
二、update的书写
string sql = "update NewsType set ParentID=" + Tp.ParentID + ",";
sql += "NewsTypeName='" + Tp.NewsTypeName + "',NewsTypeDepth=" + Tp.NewsTypeDepth + ",";
sql += "NewsTypeReadMe='" + Tp.NewsTypeReadMe + "',AddTime='" + Tp.AddTime + "',";
sql += "NewsTypeOrder=" + Tp.NewsTypeOrder;
sql += " where NewsTypeID=" + Tp.NewsTypeID;
sql += "NewsTypeName='" + Tp.NewsTypeName + "',NewsTypeDepth=" + Tp.NewsTypeDepth + ",";
sql += "NewsTypeReadMe='" + Tp.NewsTypeReadMe + "',AddTime='" + Tp.AddTime + "',";
sql += "NewsTypeOrder=" + Tp.NewsTypeOrder;
sql += " where NewsTypeID=" + Tp.NewsTypeID;
三、在DbManage类里写了两个函数

四、GridView中的“编辑”和“删除”操作
1、添加新列TemplateField,填写页眉文本
2、编辑模板----增加HyperLink LinkButton控件

删除为按钮,动作函数为
protected void LinkButton1_Click(object sender, EventArgs e)
{
LinkButton link=(LinkButton)sender;
string delid = link.CommandArgument;
News_Type_Operate table = new News_Type_Operate();
table.DelNewsType(Convert.ToInt32(delid));
GridView1.DataBind();
}
{
LinkButton link=(LinkButton)sender;
string delid = link.CommandArgument;
News_Type_Operate table = new News_Type_Operate();
table.DelNewsType(Convert.ToInt32(delid));
GridView1.DataBind();
}
转载于:https://blog.51cto.com/zcsull/148150