Download 100% FREE Office Document APIs for .NET
DotNetFunda.com
Online: 3007
Home > Forums > ASP.NET >

add two datatable in dataset

Posted by Venkatesh under ASP.NET on 4/26/2011 | Points: 10 | Views : 4379 | Status : [Member] | Replies : 1
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
Hi

i am having one dataset and one datatable.Dataset having 4 coulmns and datable having 1 coulmn.i want add this coulmn into dataset.

Thanks
Venkatesh.P



Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Ndebata on: 4/26/2011 [Member] Starter | Points: 25

Up
0
Down
lets say ds is the dataset where you want to add a column to a table 

DataTable dt2nd=new DataTable("SourceTableName");

            ds.Tables[0].Columns.Add("Cloumn5");

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

            {

                if (dt2nd.Rows.Count > i)

                    ds.Tables[0].Rows[i]["Cloumn5"] = dt2nd.Rows[i]["ColumnName"];

            }


Venkatesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response

Latest Posts