dynamic data loading without entityframework

REVATHI R

How to load dynamic data without using column names in ajax script,

datas should be from db ,

give some example,,

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

REVATHI R8y ago
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?
0
REVATHI R8y ago
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();
}
0
REVATHI R8y ago
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?
0
Chetan Ranpariya8y ago
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?
0
REVATHI R8y ago
yes,i tried lot,but i didn't get,,

can u send sample project
0
Chetan Ranpariya8y ago
There are lot of examples available on Google ? Did you try there?
0