how to get each 9 values from a list and add to data table row?

Sujeet Raman

Hi,

i have a c# list having 1000 data i need to add each 9 values with comma and quotes to table.Rows.Add(1, 2, "M", "M", "M", "M", "M", "M", "M") how can i do that? and my list staring index value is " " how can i remove ?(its not a null " " is not going when i remove).

I need to remove index 0 and take each 9 record and add like

table.Rows.Add(1, 2, "M", "M", "M", "M", "M", "M", "M")

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujeet Raman5y ago
hi thanks for this but its difficult me to understand this code.I will show how i written and what is the specific challenge i face.see my method i am trying to convert this dt to excel

public System.Data.DataTable ExportToExcel()
{
System.Data.DataTable table = new System.Data.DataTable();
table.Columns.Add("RequestID", typeof(int));
table.Columns.Add("Age", typeof(int));
table.Columns.Add("User Name ", typeof(string));
table.Columns.Add(" Target", typeof(string));
table.Columns.Add(" Resource", typeof(string));
table.Columns.Add(" Atribute value", typeof(string));
table.Columns.Add("Role", typeof(string));
table.Columns.Add("Status", typeof(string));
table.Columns.Add("Approver Status", typeof(string));
List Statuslist = new List();
string path = @"C:\status.txt";
using (FileStream fs = File.Open(path, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
using (BufferedStream bs = new BufferedStream(fs))
using (StreamReader sr = new StreamReader(bs))
{
string line;
while ((line = sr.ReadLine()) != null)
{
Statuslist.Add(line);
}
}
var str = String.Join(",", Statuslist);
string result = Regex.Replace(str, ",+", ",").Trim(',');
List TagIds = result.Split(',').ToList();
List LastList = TagIds.Where(x => x != " ").ToList();

//here in LastList i have 1000 values with comma seperated.I have to add that values like table.Rows.Add(1, 2, "M", //"M", "M", "M", "M", "M", "M") format. only 9 values so like this 9 *100
return table;
}
Alok pandey5y ago
Hi Manidas,

I think this will help you, but if you give some more details then it will really help to give an answer.

class Program
{
  static void Main(string[] args)
      {
         test t = new test();
         t.addvalue();
         Console.ReadLine();
   }
}
public class test
{
         List t = new List();
         List t2 = new List();
         DataTable MyTable = new DataTable();
         int pageSize = 9;
      public test()
      {
         MyTable.Columns.Add("c1", typeof(string));
         MyTable.Columns.Add("c2", typeof(string));
         MyTable.Columns.Add("c3", typeof(string));
         MyTable.Columns.Add("c4", typeof(string));
         MyTable.Columns.Add("c5", typeof(string));
         MyTable.Columns.Add("c6", typeof(string));
         MyTable.Columns.Add("c7", typeof(string));
         MyTable.Columns.Add("c8", typeof(string));
         MyTable.Columns.Add("c9", typeof(string));
      }
         public void addvalue()
         {
               for (int i = 1; i <= 1000; i++)
               {
                        t.Add(i);
               }
      var s = t.Count / MyTable.Columns.Count;
      var totalPage = Math.Floor((double)s);
      int count = 1;
      var currentPage = 0;
      DataRow dr = MyTable.NewRow();
      for (int i = 1; i <= t.Count - 1; i++)
      {
            if (count == MyTable.Columns.Count)
            {
                  dr[count - 1] = t[i];
                  count = 1;
                  MyTable.Rows.Add(dr);
                  dr = MyTable.NewRow();
                  currentPage++;
         }
         else
         {
               if (totalPage==currentPage)
               {
                     dr[count - 1] = t[i];
                     MyTable.Rows.Add(dr);
                 }
            else
            {
                  dr[count - 1] = t[i];
                  count++;
            }
         }
      }
   }
}

please check the data table in debug mode or you can print it as well.