Showing posts with label Data table Dynamically. Show all posts
Showing posts with label Data table Dynamically. Show all posts

Friday, 14 March 2014

How to create Data table Dynamically in C#

How to create Data table Dynamically in C#

Use This Code to  create Data table Dynamically in C#

   public void DynamicDatatable()
        {
            try
            {
                DataTable dt = new DataTable();
                DataColumn dc;//DataColumn
                dc = new DataColumn("Itemcode", typeof(string));
                dt.Columns.Add(dc);
                dc = new DataColumn("Qty", typeof(string));
                dt.Columns.Add(dc);
                dc = new DataColumn("DispQty", typeof(string));
                dt.Columns.Add(dc);
                string[] arr;
                arr = sResponse.Split('-');
                for (int i = 0; i < arr.Length - 1; i++)
                {
                    DataRow dr1 = dt.NewRow();//DataRow
                    string[] strarr = arr[i].Split('~');
                    if (strarr.Length >= 3)
                    {
                        dr1["Itemcode"] = Convert.ToString(strarr[0]);
                        dr1["Qty"] = Convert.ToString(strarr[1]);
                        dr1["DispQty"] = Convert.ToString(strarr[2]);
                        dt.Rows.Add(dr1);
                    }
                }
                this.dataGrid1.DataSource = dt.DefaultView;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }