C # database operations through XML with Flash ActionScript 2.0 (I)

C # page
Output an XML document to read XML values in as to form a list.

Sing system;
Using system. collections;
Using system. componentmodel;
Using system. Data;
Using system. drawing;
Using system. Web;
Using system. Web. sessionstate;
Using system. Web. UI;
Using system. Web. UI. webcontrols;
Using system. Web. UI. htmlcontrols;
Using system. Text. regularexpressions;
Using system. text;
Using operclass;
Using system. xml;
Namespace wqwj. flashuser
{
/// <Summary>
/// Summary of flashmessagelist. Retrieve the XML short message list
/// </Summary>
Public class flashmessagelist: system. Web. UI. Page
{
Commclass cc = new commclass ();
String userid = "";
Private void page_load (Object sender, system. eventargs E)
{
// Place the user hereCodeTo initialize the page
// Creategrid ();
Showxml ();
}

# Region output XML
/// <Summary>
/// Retrieve data and export XML
/// </Summary>
Public void showxml ()
{Userid = request. querystring ["uid"]. tostring (); // "7 ";
String sqlstr = "select top 10 * From message where receiverid = '" + userid + "' and type = 0 and (delstate = '00' or delstate = '10 ') order by id desc ";
Dataset DS = cc. getds (sqlstr, "message ");
Xmldocument xmldoc = new xmldocument (); // Add the Declaration section of XML
String xml = "<? XML version = \ "1.0 \" encoding = \ "gb2312 \"?> <List> </List> ";
Xmldoc. loadxml (XML); // Add a declaration and a root element
If (Ds. Tables [0]. Rows. Count> 0)
{
For (INT I = 0; I <Ds. Tables [0]. Rows. Count; I ++)
{
String g_id = Ds. Tables [0]. Rows [I] ["ID"]. tostring (). Trim ();
String isread = Ds. Tables [0]. Rows [I] ["isread"]. tostring (). Trim ();
String ishf = Ds. Tables [0]. Rows [I] ["ishf"]. tostring (). Trim ();
String title = commclass. strdecode (Ds. Tables [0]. Rows [I] ["title"]. tostring (). Trim ());
String content = commclass. strdecode (Ds. Tables [0]. Rows [I] ["content"]. tostring (). Trim ());
String addtime = commclass. interceptstr (Ds. Tables [0]. Rows [I] ["addtime"]. tostring (), 0, 10, false );
String uid = Ds. Tables [0]. Rows [I] ["senderid"]. tostring (). Trim ();
String nickname = cc. getdataone ("select nickname from users where blocknumber =" + uid + "");

Xmlelement xmlelem = xmldoc. createelement ("messages"); // create an element

Xmlelem. setattribute ("m_id", g_id );
Xmlelem. setattribute ("m_uid", UID );
Xmlelem. setattribute ("m_title", title );
Xmlelem. setattribute ("m_nc", nickname );
Xmlelem. setattribute ("m_content", content );
Xmlelem. setattribute ("m_addtime", addtime );

Xmldoc. documentelement. appendchild (xmlelem); // Add the element to the <list> </List> flag.
}
}
Response. Write (xmldoc. innerxml );
}
# Endregion
# Code generated by region web Form Designer
Override protected void oninit (eventargs E)
{
//
// Codegen: This call is required by the ASP. NET web form designer.
//
Initializecomponent ();
Base. oninit (E );
}

/// <Summary>
/// The designer supports the required methods-do not use the code editor to modify
/// Content of this method.
/// </Summary>
Private void initializecomponent ()
{
This. Load + = new system. eventhandler (this. page_load );
}
# Endregion
}
}
Source code download