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);
            }

        }

No comments:

Post a Comment

Note: only a member of this blog may post a comment.