add new cloumn to exsit dataset

Question

hi every body

i have folder in my website where i can loop in it and get all files ordered i need to add anew column to an exist data set this my code

string sourceDir = Server.MapPath("~/folder1/folder2/");

string[] fileEntries = Directory.GetFiles(sourceDir).OrderBy(filename => filename).ToArray();

foreach (string fileName in fileEntries)

{

string x = "<img src=\"" + Path.GetFileName(fileName) + "\" /><br />";

}

this data set already have data i need to add anew colum to the same dataset with the image path from previous code

if (ds.Tables.Count > 0)

{

// do something

}

how it can be done

Francis · Answer

I created the below example to simulate your scenario. it works fine for me: try this and let me know: DataTable table = new DataTable(childTable); DataColumn column; DataRow row; // Create first column and add to the DataTable. column = new DataColumn(); column.DataType = System.Type.GetType(System.Int32); column.ColumnName = ChildID; column.Caption = ID; // Add the column to the DataColumnCollection. table.Columns.Add(column); for (int i = 0; i { row = table.NewRow(); row[childID] = i; table.Rows.Add(row); } DataSet ds = new DataSet(); ds.Tables.Add(table); string[] filename = { a.gif b.gif c.gif d.gif e.gif }; if(ds.Tables.Count >0 ) { //grab the datatable from dataset DataTable dt=ds.Tables[0]; // Add your extra column dt.Columns.Add(YourColumnName typeof(System.String)); // to do your rest of the operation int cnt = 0; foreach(string str in filename) { dt.Rows[cnt][YourColumnName] = str; cnt = cnt + 1; } }

MR alaa · Answer

foreach (string str in filenames) { string photoname= Path.GetFileName(str); dt.Rows[cnt][pic] = photoname; cnt = cnt + 1; } i try this and works fine thank u so much

Francis · Answer

Substitute the below code wherever you want: string str = c://websites/app/images/folder1/; string[] res = str.Split('/'); string yourdesiredpath = string.Concat(/ res[5] /);

MR alaa · Answer

can i cut the full path to get only the folder with image i get (c://websites/app/images/folder1/) i need to get only (/foder1/) using the previous code ?? thanks for your helping

Francis · Answer

You are welcome! Happy to help!

MR alaa · Answer

thankx it work fine

MR alaa · Answer

i edite and update it to string sourceDir = Server.MapPath(~/Folder/folder2/); string[] fileEntries = Directory.GetFiles(sourceDir).OrderBy(filename => filename).ToArray(); foreach (string fileName in fileEntries) { // string photo =  ; string photo = Path.GetFileName(fileName); ds.Tables[0].Columns.Add(pic); DataRow[] drst = ds.Tables[0].Select(pic= + photo); drst[0][pic] = photo; } but always gets me error it choose first file as column but suppose its add file name to column pic why it gets me error

Francis · Answer

Your code is also working fine. There are multiple ways to achieve your need. If your code full fill your need than it's fine. :)

MR alaa · Answer

what about this ds.Tables[0].Columns.Add(pic typeof(string)); List studintPic = new List (); for (int i = 0; i { studintPic.Add(file[i].Name); DataRow[] drst = ds.Tables[0].Select(Id= + file[i].Name); ; drst[0][pic] = file[i].Name; }

Francis · Answer

You can't add a column to a dataset. Dataset is a collection of datatable. So you could add your column to the datatable. Your code will be look like below: DataSet ds = new DataSet(); if(ds.Tables.Count >0 ) { //grap the datatable from dataset DataTable dt=ds.Tables[0]; // Add your extra column dt.Columns.Add(YourColumnName typeof(System.String)); // to do your rest of the operation }