dynamic data loading without entityframework

Question

How to load dynamic data without using column names in ajax script, datas should be from db , give some example,,

REVATHI R · Answer

I need to display data from code behind to the grid and columns to be added dynamically depending on the data content. anyone can help?

REVATHI R · Answer

Here is my conn of repository pattern: public string _conn = ConfigurationManager.ConnectionStrings["ConnStr"].ToString(); public List LoadLargeRecd() { try { using (SqlConnection con = new SqlConnection(_conn)) { con.Open(); string query1 = "select suid,Barcode,Manufacturer,ModelNumber from DataItem1"; var res = con.Query (query1); return res.ToList(); }

REVATHI R · Answer

Here is my view: var table = $('#tblItems').DataTable({ "processing": true, "serverSide": true, "ajax": { "url": "/DataGrid/LoadData", "type": "GET", "datatype": "json" } in this script i don't use column names, i just load datas to grid view using mvc,, my question is how can i load dynamic data to grid,with out mentioning any column name in this script,, can u provide any sample project sir?

Chetan Ranpariya · Answer

Can you provide some more details with the functionality and use case so that a proper solution can be provided? What do you mean by without using column name? Are you able to retrieve data from database using normal SQL Connection, SQL Command and query? Does that code work with AJAX? What issue you are facing with code?

REVATHI R · Answer

yes,i tried lot,but i didn't get,, can u send sample project

Chetan Ranpariya · Answer

There are lot of examples available on Google ? Did you try there?