I tried using your code
ds.Tables[0].Columns.Add("S hift2", typeof(int));
ds.Tables[0].Columns.Add("S hift3", typeof(int)) ;
for (int i = 0; i<ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["Shift2"] = mySecondDS.Tabl es[0].Rows[i]["Shift2"];
...
User Profile
Collapse
-
thanks for the reply.. but the table you provided me is that a single sqlAdapter table or a dataset. sorry maybe i am not clear about my question.
i want to iterate through my dataset and delete all duplicate column and leave the value column and add into a newer column. for example
here is my result of my code:
this is my Dataset and it will look this in my gridview
Description ResultValue...Leave a comment:
-
Is it possible to JOIN a Dataset table? ASP.NET
For example in my code i am calling three slqadapter and stored it into three dataset.
Dataset 1
Description Shift1
PRINT 2
MOUSE 3
MONITOR 1
dataset 2
Description Shift2
PRINT 1
MOUSE 1
MONITOR 1
dataset 3
Description Shift3
...
No activity results to display
Show More
Leave a comment: