add new cloumn to exsit dataset

MR alaa

10y1.1k.NET

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 = "

}

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

10 Replies

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

Francis Susaimichael10y ago
Accepted 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 <= 4; 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 alaa10y ago
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 Susaimichael10y ago
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 alaa10y ago
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 Susaimichael10y ago
You are welcome! Happy to help!
MR alaa10y ago
thankx it work fine
MR alaa10y ago
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 Susaimichael10y ago
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 alaa10y ago
what about this

ds.Tables[0].Columns.Add("pic", typeof(string));
List studintPic = new List();
for (int i = 0; i < 10; i++)
{
studintPic.Add(file[i].Name);
DataRow[] drst = ds.Tables[0].Select("Id=" + file[i].Name); ;
drst[0]["pic"] = file[i].Name;
}
Francis Susaimichael10y ago
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
}