新闻网站aspnet课程设计报告样本

河南中医学院《ASP.NET课程设计报告》所在院系：信息技术学院专业年级：级计算机科学与技术完毕学生：180106曽涛指引教师：曹莉ASP.NET课程设计报告-新闻网站目录HYPERLINK+message+"')</script>"，false);}publicstaticvoidAlert(stringmessage，Pagepage)//显示对话框{page.Response.Write("<scriptlanguage='javascript'type='text/javascript'>functionwindow.onload(){alert('"+message+"');}</script>");}publicstaticvoidMsgBox(stringmessage，Pagepage)//显示对话框{Stringcsname="PopupScript";//定义客户端脚本名Typecstype=page.GetType();//定义客户端脚本类型ClientScriptManagercs=page.ClientScript;//创立一种ClientScriptManager类if(!cs.IsStartupScriptRegistered(cstype，csname))//如果脚本没有注册{Stringcstext="alert('"+page.Server.HtmlEncode(message)+"');";cs.RegisterStartupScript(cstype，csname，cstext，true);}}publicstaticvoidMsgBox(stringmessage，stringurl，Pagepage){ClientScriptManagercs=page.ClientScript;//创立一种ClientScriptManager类Stringcsname="PopupScript";//定义客户端脚本名Typecstype=page.GetType();//定义客户端脚本类型if(!cs.IsStartupScriptRegistered(cstype，csname))//如果脚本没有注册{Stringcstext="alert('"+page.Server.HtmlEncode(message)+"');window.location='"+url+"';";cs.RegisterStartupScript(cstype，csname，cstext，true);}}publicvoidAlertBox(stringmessage，stringurl){System.Web.HttpContext.Current.Response.Write("<script>alert('"+message+"');location.href('"+url+"')</script>");}publicstaticvoidCClose(Pagepage){//GetaClientScriptManagerreferencefromthePageclassClientScriptManagercs=page.ClientScript;//DefinethenameandTypeoftheclientscriptonthepageStringcsname="close";Typecstype=page.GetType();//builderthescripttextStringBuildercstext=newStringBuilder();cstext.Append("<scriptlanguage='javascript'>");cstext.Append("{window.opener='anyone';window.close();}");cstext.Append("</script>");//Checktoseeifthestartupscriptisalreadyregisteredif(!cs.IsClientScriptBlockRegistered(cstype，csname)){cs.RegisterStartupScript(cstype，csname，cstext.ToString());}}//或inti=SqlHelper.GetExecuteNonQuery(sqlStr);publicstaticintGetExecuteNonQuery(stringsqlStr){OpenConnection();//打开连接cmd.CommandType=CommandType.Text;//定义为使用SQL语句cmd.CommandText=sqlStr;//初始化Command对象SQL字符串intresult=cmd.ExecuteNonQuery();//执行SQL语句并返回受影响行数CloseConnection();//关闭连接returnresult;//返回整数}publicstaticintGetExecuteNonQuery(stringsqlStr，paramsSqlParameter[]values){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;cmd.Parameters.AddRange(values);//添加参数集intresult=cmd.ExecuteNonQuery();CloseConnection();cmd.Parameters.Clear();returnresult;}publicstaticobjectGetExecuteScalar(stringsqlStr){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;objectresult=cmd.ExecuteScalar();//执行SQL语句CloseConnection();returnresult;//返回获得单个值}publicstaticobjectGetExecuteScalar(stringsqlStr，paramsSqlParameter[]values){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;cmd.Parameters.Clear();cmd.Parameters.AddRange(values);objectresult=cmd.ExecuteScalar();CloseConnection();cmd.Parameters.Clear();returnresult;}publicstaticSqlDataReaderGetExecuteReader(stringsqlStr){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;SqlDataReaderreader=cmd.ExecuteReader();//这里不能关闭连接CloseConnection()，要在调用中关闭returnreader;}publicstaticSqlDataReaderGetDataReader(stringsqlStr，paramsSqlParameter[]values){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;cmd.Parameters.AddRange(values);SqlDataReaderreader=cmd.ExecuteReader();//这里不能关闭连接CloseConnection()，要在调用中关闭cmd.Parameters.Clear();returnreader;}publicstaticDataSetGetDataSet(stringsqlStr){SqlDataAdapterda=newSqlDataAdapter();OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;da.SelectCommand=cmd;DataSetds=newDataSet();da.Fill(ds);CloseConnection();returnds;//返回DataSet对象}publicstaticDataSetGetDataSet(stringsqlStr，paramsSqlParameter[]values){SqlDataAdapterda=newSqlDataAdapter();OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;cmd.Parameters.AddRange(values);da.SelectCommand=cmd;DataSetds=newDataSet();da.Fill(ds);CloseConnection();cmd.Parameters.Clear();returnds;//返回DataSet对象}publicstaticDataSetGetDataSet(stringsqlStr，stringtableName){SqlDataAdapterda=newSqlDataAdapter();OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;da.SelectCommand=cmd;DataSetds=newDataSet();da.Fill(ds，tableName);CloseConnection();returnds;//返回DataSet对象}publicstaticDataTableGetDataTable(StringsqlStr){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;DataTabledt=newDataTable();//创立一种数据表dtSqlDataAdapterda=newSqlDataAdapter(cmd);//定义并初始化数据适配器da.Fill(dt);//将数据适配器中数据填充到数据集dt中CloseConnection();returndt;}publicstaticDataTableGetDataTable(stringsqlStr，paramsSqlParameter[]values){OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;cmd.Parameters.AddRange(values);DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter(cmd);da.Fill(ds);CloseConnection();cmd.Parameters.Clear();returnds.Tables[0];}publicstaticDataViewGetDataView(stringsqlStr){SqlDataAdapterda=newSqlDataAdapter();DataViewdv=newDataView();DataSetds=newDataSet();OpenConnection();cmd.CommandType=CommandType.Text;cmd.CommandText=sqlStr;da.SelectCommand=cmd;da.Fill(ds);dv=ds.Tables[0].DefaultView;CloseConnection();returndv;}publicstaticvoidGetAlert(stringmessage，Pagepage)//显示对话框{page.ClientScript.RegisterStartupScript(page.GetType()，"","<scriptlanguage='javascript'type='text/javascript'>alert('"+message+"')</script>"，false);}publicstaticvoidAlert(stringmessage，Pagepage)//显示对话框{page.Response.Write("<scriptlanguage='javascript'type='text/javascript'>functionwindow.onload(){alert('"+message+"');}</script>");}//调用办法：SqlHelper.Alert("您已经被禁止登录,请关闭本页后稍后再登录！"，Page);///<summary>///警告窗口,服务器端弹出alert对话框,弹出对话框而不丢失背景///</summary>///<paramname="message">提示信息,例子："不能为空!"</param>///<paramname="page">Page类</param>publicstaticvoidMsgBox(stringmessage，Pagepage)//显示对话框{Stringcsname="PopupScript";//定义客户端脚本名Typecstype=page.GetType();//定义客户端脚本类型ClientScriptManagercs=page.ClientScript;//创立一种ClientScriptManager类if(!cs.IsStartupScriptRegistered(cstype，csname))//如果脚本没有注册{Stringcstext="alert('"+page.Server.HtmlEncode(message)+"');";cs.RegisterStartupScript(cstype，csname，cstext，true);}}publicstaticvoidMsgBox(stringmessage，stringurl，Pagepage){ClientScriptManagercs=page.ClientScript;//创立一种ClientScriptManager类Stringcsname="PopupScript";//定义客户端脚本名Typecstype=page.GetType();//定义客户端脚本类型if(!cs.IsStartupScriptRegistered(cstype，csname))//如果脚本没有注册{Stringcstext="alert('"+page.Server.HtmlEncode(message)+"');window.location='"+url+"';";cs.RegisterStartupScript(cstype，csname，cstext，true);}}publicvoidAlertBox(stringmessage，stringurl){System.Web.HttpContext.Current.Response.Write("<script>alert('"+message+"');location.href('"+url+"')</script>");}publicstaticvoidCClose(Pagepage){//GetaClientScriptManagerreferencefromthePageclassClientScriptManagercs=page.ClientScript;//Defineth