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 suidBarcodeManufacturerModelNumber 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 gridwith 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

yesi tried lotbut i didn't get can u send sample project

Chetan Ranpariya · Answer

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