No response BIND Data to gridview using jquery

Francky Frined

8y869AJAX

Pls help why no response BIND Data to gridview using jquery as below:-

1) WebForm6.aspx

"text/javascript"> src="http://code.jquery.com/jquery-1.11.1.min.js"
"text/javascript">
$(document).ready(function () {
BindGridView();
});
function BindGridView() {
$.ajax({
type: "POST",
url: "WebForm6.aspx/GetData",
contentType: "application/json;charset=utf-8",
data: {},
dataType: "json",
success: function (data) {
$("#grdDemo").empty();
if (data.d.length > 0) {
$("#grdDemo").append("UsernameFirstname"); //LastnameEmailID
for (var i = 0; i < data.d.length; i++) {
$("#grdDemo").append("" +
data.d[i].Firstname + " " +
data.d[i].Lastname + "");
}
}
},
error: function (result) {
alert("Error login");
}
});
}

2) WebForm6.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
BindDummyItem();
}
public void BindDummyItem()
{
DataTable dtGetData = new DataTable();
dtGetData.Columns.Add("Username");
dtGetData.Columns.Add("Firstname");
//dtGetData.Columns.Add("Lastname");
//dtGetData.Columns.Add("EmailID");
dtGetData.Rows.Add();
grdDemo.DataSource = dtGetData;
grdDemo.DataBind();
}
[WebMethod]
public static DetailsClass[] GetData() //GetData function
{
List Detail = new List();
string SelectString = "SELECT Username,Firstname FROM TABLE";
OracleConnection cn = new OracleConnection();
cn.ConnectionString = "Data Source=(DESCRIPTION ="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxx)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxxx)));"
+ "User Id=xxx;Password=xxxxxx;";
OracleCommand cmd = new OracleCommand(SelectString, cn);
cn.Open();
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach(DataRow dtRow in dtGetData.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.Username = dtRow["Username"].ToString();
DataObj.Firstname = dtRow["Firstname"].ToString();
Detail.Add(DataObj);
}
return Detail.ToArray();
}
public class DetailsClass //Class for binding data
{
public string Username { get; set; }
public string Firstname { get; set; }
}

7 Replies

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

Francky Frined8y ago
When retrieve data more than 150 records, error persists. If less than that, the data get display on the web page. Please help tell me why and how rectify the code if needed. Thanks
0
Asma Khalid8y ago
Do accept the answer if your issue is resolved. The max record will be the amount of data you have loaded in your list.
0
Francky Frined8y ago
Now, it's ok. However what will be the List maximum records can retrieve.
0
Francky Frined8y ago
Remove Detail before GetData name, please help to check why still no data retrieve from server using below JSON format display in web site:-
function BindGridView() {
$.ajax({
type: "POST",
url: "WebForm6.aspx/GetData",
contentType: "application/json;charset=utf-8",
data: {},
dataType: "json",
success: function (data) {
$("#grdDemo").empty();
if (data.d.length > 0) {
$("#grdDemo").append("UsernameFirstname"); //LastnameEmailID
for (var i = 0; i < data.d.length; i++) {
$("#grdDemo").append("" +
data.d[i].Firstname + " " +
data.d[i].Lastname + "");
}
}
},
error: function (result) {
alert("Error login");
}
});
}
0
Asma Khalid8y ago
There is a typo mistake here. Remove Detail before GetData name i.e.
public static List GetData() //GetData function
Above line of code is valid function definition.
0
Francky Frined8y ago
After change code , still have the below red highlighted error as below:-
Please help

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
public static List Detail GetData() //GetData function
{
List Detail = new List();
string SelectString = SELECT USERNAME,FIRSTNAME FROM TABLE";
OracleConnection cn = new OracleConnection();
cn.ConnectionString = "Data Source=(DESCRIPTION ="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxxx)));"
+ "User Id=xxxx;Password=xxxxxxxx;";
OracleCommand cmd = new OracleCommand(SelectString, cn);
cn.Open();
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach(DataRow dtRow in dtGetData.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.Username = dtRow["USERNAME"].ToString();
DataObj.Firstname = dtRow["FIRSTNAME "].ToString();
Detail.Add(DataObj);
}
return Detail;
}

0
Asma Khalid8y ago
Correct your web method as follow i.e.
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
public static List GetData() //GetData function
{
     List Detail = new List();

    string SelectString = "SELECT Username,Firstname FROM TABLE";
    OracleConnection cn = new OracleConnection();
   cn.ConnectionString = "Data Source=(DESCRIPTION ="
   + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)      HOST=xxx.xxx.xxx.xxx)(PORT=xxx)))"
   + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxxx)));"
   + "User Id=xxx;Password=xxxxxx;";
   OracleCommand cmd = new OracleCommand(SelectString, cn);
   cn.Open();
   OracleDataAdapter da = new OracleDataAdapter(cmd);

    DataTable dtGetData = new DataTable();
   da.Fill(dtGetData);

   foreach(DataRow dtRow in dtGetData.Rows)
   {
         DetailsClass DataObj = new DetailsClass();
         DataObj.Username = dtRow["Username"].ToString();
        DataObj.Firstname = dtRow["Firstname"].ToString();
        Detail.Add(DataObj);
    }

    return Detail;
}
I have made changes in red. The issue that I see here is that you are returning unstructured array and at ajax call you are trying to access structured data of DetailClas type.
0