博客制作代码.docVIP

博客制作代码 using System; using System.Collections; using System.Collections.Generic; using System.Configuration; using System.Data;//添加DateSet类所在的命名空间 using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient;//添加数据库访问类的命名空间 public partial class BlogManager_BlogType : System.Web.UI.Page { private static int blogid = -1; protected void Page_Load(object sender, EventArgs e) { if (null == Session[name]) { Response.Redirect(~/login.aspx); } if (!IsPostBack)//页面首次加载 { blogid = GetBlogId(); GVBind(); } } /// summary /// 从数据库中读取类型信息，显示在GridView上 /// /summary private void GVBind() { //读取数据 String strsql = select * from ST_class where BlogId=@id; SqlParameter[] parms = { new SqlParameter (id,System .Data .SqlDbType .Int ), }; parms[0].Value = blogid; DataSet ds = SqlHelper.ExectueDataSet(strsql, parms); //和GridView控件绑定，显示 gv_datalist.DataSource = ds.Tables[0]; gv_datalist.DataBind(); } /// summary /// 通过会员名，来获得会员编号 /// /summary /// returns/returns private int GetBlogId() { String sqlstr = select BlogId from tb_Blog where Username=@name; //定义参数，并指定参数类型 SqlParameter []parms={ new SqlParameter (@name,System .Data .SqlDbType .NVarChar,50), }; //给参数赋值 parms[0].Value = Session[name].ToString(); SqlConnection conn = SqlHelper.GetConnection(); SqlDataReader dr = SqlHelper.ExectueReader(sqlstr, parms, conn); int id = -1; if (dr.Read()) { id = Convert.ToInt32(dr[0]); } dr.Close(); conn.Cl