Click here to Skip to main content
15,905,508 members
Home / Discussions / ASP.NET
   

ASP.NET

 
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 
QuestionCustom /efficient paging and sorting gridview Pin
mark_me7-Aug-09 17:33
mark_me7-Aug-09 17:33 
AnswerRe: Custom /efficient paging and sorting gridview Pin
N a v a n e e t h7-Aug-09 17:59
N a v a n e e t h7-Aug-09 17:59 
GeneralRe: Custom /efficient paging and sorting gridview Pin
mark_me7-Aug-09 18:19
mark_me7-Aug-09 18:19 
GeneralRe: Custom /efficient paging and sorting gridview Pin
N a v a n e e t h7-Aug-09 18:30
N a v a n e e t h7-Aug-09 18:30 
GeneralRe: Custom /efficient paging and sorting gridview Pin
mark_me7-Aug-09 18:57
mark_me7-Aug-09 18:57 
QuestionSQL NOT WORKING Pin
greendragons7-Aug-09 9:30
greendragons7-Aug-09 9:30 
AnswerRe: SQL NOT WORKING Pin
Abhijit Jana7-Aug-09 10:36
professionalAbhijit Jana7-Aug-09 10:36 
AnswerRe: SQL NOT WORKING Pin
Abhishek Sur7-Aug-09 10:49
professionalAbhishek Sur7-Aug-09 10:49 
Questionwraper controls Pin
greendragons7-Aug-09 9:22
greendragons7-Aug-09 9:22 
AnswerRe: wraper controls Pin
Abhijit Jana7-Aug-09 10:39
professionalAbhijit Jana7-Aug-09 10:39 
GeneralRe: wraper controls Pin
greendragons7-Aug-09 10:47
greendragons7-Aug-09 10:47 
GeneralRe: wraper controls Pin
Abhijit Jana7-Aug-09 11:07
professionalAbhijit Jana7-Aug-09 11:07 
QuestionAccess frames on different domain from Frameset Pin
Hemant_ec487-Aug-09 9:15
Hemant_ec487-Aug-09 9:15 
AnswerRe: Access frames on different domain from Frameset Pin
Leonardo Muzzi7-Aug-09 10:30
Leonardo Muzzi7-Aug-09 10:30 

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.