.net从数据库读取信息动态生成xml

最新推荐文章于 2024-10-05 14:16:38 发布

play_cc

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量417

点赞数

分类专栏： .net 文章标签：数据库 .net dataset import image encoding

本文链接：https://blog.csdn.net/play_cc/article/details/4467479

版权

.net 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%
int AdminLogFlag,PageSize=15,intPageCount,intRecordCount,Page;
bool AllowUbbCode=false;

if( Session["AdminLogged"]!="1" )
AdminLogFlag=0;
else{
AdminLogFlag=1;
}

if (Request["Page"]==null||Request["Page"]=="")
Page=1;
else{

   Page=Convert.ToInt32((Request["Page"]));
   if (Page<1)
    Page=1;

}
string DB_STR="Provider=Microsoft.Jet.OLEDB.4.0; Persist Security Info=False; Data Source=" + Server.MapPath("../data/data.mdb");
     OleDbConnection conn = new OleDbConnection( DB_STR );
     OleDbCommand     cmd = new OleDbCommand( "select * from gbook order by posttime DESC", conn );
     OleDbDataAdapter da   = new OleDbDataAdapter();
     da.SelectCommand = cmd;
     DataSet ds = new DataSet();
     da.Fill( ds );
     conn.Close();
DataTable msgTable=ds.Tables[0];
intRecordCount=msgTable.Rows.Count;
Response.ContentType = "text/xml";
Response.Expires = -1;
Response.Write("<?xml version='1.0' encoding='GB2312'?>");
Response.Write("<leave ");
if(intRecordCount>0){
   intPageCount=intRecordCount/PageSize+1;
   if ( intRecordCount%PageSize>0 )intPageCount++;
        if ( intPageCount<1 )intPageCount=1;
   if(Page>intPageCount)
    Page=intPageCount;

        //Response.Write("PageCount=/""+Convert.ToString(intPageCount)+"/" RecordCount=/""+Convert.ToString(intRecordCount)+"/" AdminLog=/""+Convert.ToString(AdminLogFlag)+"/">");
        Response.Write("PageCount=/"" + Convert.ToString(intPageCount) + "/" RecordCount=/"" + Convert.ToString(intRecordCount) + "/">");
int msgWrote=(Page-1)*PageSize;
   for(int i=0 ; i< PageSize;i++){
    if(msgWrote>intRecordCount-1)break;
   Response.Write("<mes>");

        Response.Write("<name>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["name"]);
        Response.Write("</name>");

        Response.Write("<email>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["email"]);
        Response.Write("</email>");

        Response.Write("<qq>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["qq"]);
        Response.Write("</qq>");

        Response.Write("<url>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["url"]);
        Response.Write("</url>");

        Response.Write("<posttime>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["posttime"]);
        Response.Write("</posttime>");

        Response.Write("<image>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["image"]);
        Response.Write("</image>");

        Response.Write("<reply>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["reply"]);
        Response.Write("</reply>");

        Response.Write("<title>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["title"]);
        Response.Write("</title>");

        Response.Write("<content>");
        Response.Write(msgTable.Rows[i + (Page - 1) * PageSize]["content"]);
        Response.Write("</content>");

   Response.Write("</mes>");
   msgWrote++;
   }
}

Response.Write("</leave>");
%>