Click here to Skip to main content
15,888,610 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
DataClassesLINQ_SQLDataContext db = new DataClassesLINQ_SQLDataContext();

            var data = from sel in db.CustomerTBLs select sel;


            DataTable dt = new DataTable();
            if (data.Any())
            {
                Type t = data.First().GetType();
                foreach (PropertyInfo p in t.GetProperties())
                {
                    // Get the name of the prperty

                    dt.Columns.Add(p.Name);
                }
            }

           
            int j = 0;
            foreach (var rowObj in data)
            {


                DataRow dr = dt.NewRow();
                dt.Rows.Add(dr);
                dt.Rows[j][0] = rowObj.Id;
                dt.Rows[j][1] = rowObj.Customername;
                dt.Rows[j][2] = rowObj.Address;
                dt.Rows[j][3] = rowObj.Mobile;
                j = j + 1;


                
            }

            EmpModel em = new EmpModel();
            em.ShowData = dt;
            return View(em);
        }


// Don't want to specify Column name, Any suggestion.???
Posted
Updated 9-May-14 3:18am
v2
Comments
Sampath Lokuge 9-May-14 9:21am    
What's wrong with your effort ? any errors or what ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900