Click here to Skip to main content
16,008,954 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Loading windows forms in to asp.net Pin
Abhijit Jana7-Aug-09 22:01
professionalAbhijit Jana7-Aug-09 22:01 
GeneralLoading windows forms in to asp.net Pin
kavinnagarajan7-Aug-09 22:23
kavinnagarajan7-Aug-09 22:23 
QuestionSentence colouring in Mail Pin
kavinnagarajan7-Aug-09 20:43
kavinnagarajan7-Aug-09 20:43 
AnswerRe: Sentence colouring in Mail Pin
Abhijit Jana7-Aug-09 20:49
professionalAbhijit Jana7-Aug-09 20:49 
GeneralSentence colouring in Mail Pin
kavinnagarajan7-Aug-09 20:52
kavinnagarajan7-Aug-09 20:52 
GeneralRe: Sentence colouring in Mail Pin
Abhijit Jana7-Aug-09 20:57
professionalAbhijit Jana7-Aug-09 20:57 
GeneralSentence colouring in Mail Pin
kavinnagarajan7-Aug-09 21:06
kavinnagarajan7-Aug-09 21:06 
AnswerRe: Sentence colouring in Mail Pin
Abhijit Jana7-Aug-09 21:28
professionalAbhijit Jana7-Aug-09 21:28 
Question[Message Deleted] Pin
kavinnagarajan7-Aug-09 19:43
kavinnagarajan7-Aug-09 19:43 
AnswerRe: Multiline Textbox with Home address Pin
mylogics7-Aug-09 20:13
professionalmylogics7-Aug-09 20:13 
AnswerRe: Multiline Textbox with Home address Pin
N a v a n e e t h7-Aug-09 20:24
N a v a n e e t h7-Aug-09 20:24 
AnswerTextbox with Home address Pin
kavinnagarajan7-Aug-09 20:24
kavinnagarajan7-Aug-09 20:24 
GeneralRe: Textbox with Home address Pin
N a v a n e e t h7-Aug-09 20:28
N a v a n e e t h7-Aug-09 20:28 
GeneralTextbox with Home address Pin
kavinnagarajan7-Aug-09 20:38
kavinnagarajan7-Aug-09 20:38 
QuestionMail Pin
kavinnagarajan7-Aug-09 19:35
kavinnagarajan7-Aug-09 19:35 
AnswerRe: Mail Pin
Abhijit Jana7-Aug-09 20:01
professionalAbhijit Jana7-Aug-09 20:01 
Questionhow to reduce downloading time video file Pin
reogeo20087-Aug-09 19:05
reogeo20087-Aug-09 19:05 
AnswerRe: how to reduce downloading time video file Pin
N a v a n e e t h7-Aug-09 19:18
N a v a n e e t h7-Aug-09 19:18 
Questioninclude file in aspx page from codebehind file. Pin
adkalavadia7-Aug-09 18:59
adkalavadia7-Aug-09 18:59 
AnswerRe: include file in aspx page from codebehind file. Pin
r a m e s h7-Aug-09 19:15
r a m e s h7-Aug-09 19:15 
AnswerRe: include file in aspx page from codebehind file. Pin
N a v a n e e t h7-Aug-09 19:16
N a v a n e e t h7-Aug-09 19:16 
Questionconvert database to xml file (but i want column as attribute) [modified] Pin
Punit Belani7-Aug-09 18:00
Punit Belani7-Aug-09 18:00 
hi.. i already convert database table to xml but it create new element for each column but i want each column as attribute..

code i have is as below:

public partial class Default2 : System.Web.UI.Page
{
      protected void Page_Load(object sender, EventArgs e)
      {
            DataSet ds = GetDataSet();
            myXMLControl.DocumentContent = ds.GetXml();
           
      }
      public DataSet GetDataSet()
      {
            DataSet result = new DataSet();
            string connString
                  = "server=192.0.0.1;user id=test;password=123;persist security info=True;database=MLM1";
            using (MySqlConnection myConnection = new MySqlConnection(connString))
            {
                  string query
                        = "Select userid,code,parent_id from _relation";
                  MySqlCommand myCommand = new MySqlCommand(query, myConnection);
                  MySqlDataAdapter myAdapter = new MySqlDataAdapter();
                  myCommand.CommandType = CommandType.Text;
                  myAdapter.SelectCommand = myCommand;
                  myAdapter.Fill(result);
                  myAdapter.Dispose();
            }

            result.DataSetName = "root";
            result.Tables[0].TableName = "Node";
            DataRelation relation = new DataRelation("ParentChild",//tab.Columns.Add("userid"),tab.Columns.Add("parent_id"),true);
                        result.Tables["Node"].Columns["userid"],
                        result.Tables["Node"].Columns["parent_id"]);
           
            relation.Nested = true;
            result.Relations.Add(relation);

            result.WriteXml(@"C:\punit\vs2008\Copy of prac\demo.xml");
            return result;
           
      }
}


and i get xml file converted as:

<?xml version="1.0" standalone="yes"?>
<root>
   <Node>
      <userid>1</userid>
      <code>1VXZ0709</code>
      <parent_id>0</parent_id>
      <Node>
         <userid>2</userid>
         <code>2PJB0709</code>
         <parent_id>1</parent_id>
      </Node>
   </Node>
</root>

but iwant result as below:
<?xml version="1.0" standalone="yes"?>

   <Node userid="1" code="1VXZ0709" parent_id="0">
      <Node userid="2" code="2PJB0709" parent_id="1">
      </Node>
   </Node>

thanks in advance....
regards... Smile | :)

modified on Saturday, August 8, 2009 1:07 AM

AnswerRe: convert database to xml file (but i want column as attribute) Pin
N a v a n e e t h7-Aug-09 18:43
N a v a n e e t h7-Aug-09 18:43 
GeneralRe: convert database to xml file (but i want column as attribute) Pin
Punit Belani7-Aug-09 18:51
Punit Belani7-Aug-09 18:51 
GeneralRe: convert database to xml file (but i want column as attribute) Pin
N a v a n e e t h7-Aug-09 19:09
N a v a n e e t h7-Aug-09 19:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.