C# .NET - how to add rows and columns to a datatable in aps.net

Asked By Durga Devi on 20-Dec-06 04:29 AM

hi,


i need to add rows and columns dynamically to datatable,using datatable as datasource i need to fill the datagrid with the datatable data.

add rows and columns to a datatable in aps.net - K Pravin Kumar Reddy replied to Durga Devi on 20-Dec-06 04:43 AM

//Create an instance of DataTable

        DataTable dt = new DataTable();

       

        //Create an ID column for adding to the Datatable

        DataColumn dcol = new DataColumn(ID ,typeof(System.Int32));

        dcol.AutoIncrement = true;

        dt.Columns.Add(dcol);

 

        //Create an ID column for adding to the Datatable

        dcol = new DataColumn(NAME, typeof(System.String));

        dt.Columns.Add(dcol);

 

        //Now add data for dynamic columns

        //As the first column is auto-increment, we do not have to add any thing.

        //Let's add some data to the second column.

        for (int nIndex = 0; nIndex < 10; nIndex++)

        {

            //Create a new row

            DataRow drow = dt.NewRow();

 

            //Initialize the row data.

            drow[NAME] = "Row-" + Convert.ToString((nIndex + 1));

 

            //Add the row to the datatable.

            dt.Rows.Add(drow);

        }

        #endregion

 

        //Iterate through the columns of the datatable to set the data bound field dynamically.

        foreach (DataColumn col in dt.Columns)

        {

            //Declare the bound field and allocate memory for the bound field.

            BoundField bfield = new BoundField();

 

            //Initalize the DataField value.

            bfield.DataField = col.ColumnName;

 

            //Initialize the HeaderText field value.

            bfield.HeaderText = col.ColumnName;

 

            //Add the newly created bound field to the GridView.

            GrdDynamic.Columns.Add(bfield);

        }

 

        //Initialize the DataSource

        GrdDynamic.DataSource = dt;

 

        //Bind the datatable with the GridView.

        GrdDynamic.DataBind();

reference

http://www.codeproject.com/useritems/dynamic_Columns_in_Grid.asp?df=100&forumid=281011&exp=0&select=1612728

 

 http://www.csharphelp.com/archives/archive42.html

http://www.csharp-home.com/index/tiki-read_article.php?articleId=46

use datatable.Rows.Add(newDataRow) - Senthil T. replied to Durga Devi on 20-Dec-06 05:34 AM

refer the code

DataRow newDataRow = datatable.NewRow();
                    newDataRow["Feature"] = "Name";
                    newDataRow["Value"] = "Sen";
                    datatable.Rows.Add(newDataRow);