C#

<?xml version="1.0" encoding="utf-8"?>
<MAIN>
  <Items>
    <Name>name1</Name>
    <Data>data1</Data>
    <Category>category1</Category>
  </Items>
  <Items>
    <Name>name2</Name>
    <Data>data2</Data>
    <Category>category2</Category>
  </Items>
  <Items>
    <Name>name3</Name>
    <Data>data3</Data>
    <Category>category2</Category>//same category as above
  </Items>
  ...
  ...
  <Items>
    <Name>name20</Name>
    <Data>data20</Data>
    <Category>category16</Category>
  </Items>
</MAIN>

Now I need to create an List with category1, category2, ... upto what the categories is there on Category Node, need to create a separate Lists of each category to store the item name and every item list will have data of the item so I can retrieve them for my use.

From above sample xml I need the same category items in a single List

Items and Category count is fully dynamic. How to do this dynamically?

double length = axWindowsMediaPlayer.Length

SmppClient client = new SmppClient();
SmppConnectionProperties properties = new SmppConnectionProperties();
TextMessage msg = new TextMessage();

client = new SmppClient();

properties = client.Properties;
properties.SystemID = txtUserID.Text;
properties.Password = txtPassword.Text;
properties.Port = Convert.ToInt32(txtPort.Text); //IP port to use
properties.Host = txtIP.Text;
properties.SystemType = txtType.Text;
properties.DefaultServiceType = ServiceType.DEFAULT;

client.AutoReconnectDelay = 3000;
client.KeepAliveInterval = 30000;

client.Start();

if (client.ConnectionState != SmppConnectionState.Connected) client.ForceConnect(5000);

// send message now
msg = new TextMessage();

msg.DestinationAddress = txtMobile.Text;
msg.SourceAddress = txtSenderID.Text;
msg.Text = txtMessage.Text;
msg.RegisterDeliveryNotification = true; //I want delivery notification for this message

// if (client.ConnectionState != SmppConnectionState.Connected) client.ForceConnect(5000);

client.SendMessage(msg, 1000);

client.Shutdown();

OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = global::System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM Table1 WHERE RFID = '" + textBox1.Text + "'"; 
cmd.Connection = myCon;
this.table1TableAdapter.Adapter.SelectCommand = cmd;
this.table1TableAdapter.Adapter.Fill(mdb11DataSet.Table1); 

dgvConnect = new NominalRollDBConnection();
conString = Properties.Settings.Default.NominalRollCS;
dgvConnect.connection_string = conString;
dgvConnect.Sql1 = "SELECT * FROM NominalRoll WHERE RFID = '" + textBox1.Text + "'";
ds = dgvConnect.GetConnection1;
 this.nominalRollTableAdapter.Fill(nominalRollDataSet.NominalRoll);


// my connection class

class NominalRollDBConnection
    {
        private string strCon;
        private string sql_string1;
       
        System.Data.SqlClient.SqlDataAdapter da_1;


        public string Sql1
        {
            set { sql_string1 = value; }

        }


        public string connection_string
        {
            set { strCon = value; }
        }


        public System.Data.DataSet GetConnection1
        {
            get
            { return MyDataSet1(); }

        }

     
private System.Data.DataSet MyDataSet1()
{

System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string1, con);

System.Data.DataSet dat_set = new System.Data.DataSet();
 System.Data.DataTable dat_table = new System.Data.DataTable();
da_1.Fill(dat_set, "Table_Data_1");
con.Close();
return dat_set;
}