Pls help to check why bind data to gridview no data reponse

Francky Frined

8y700AJAX

Pls help to check why bind data to gridview no data reponse as below:-

1) WebForm3.aspx

"DataDetails">

Code Behind

2) Fetch.aspx Code Behind

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
public string GetData(string JO_NO)
{
string res = "
No customer selected
";
string st = "Data Source=(DESCRIPTION ="
+ "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxxx)));"
+ "User Id=xxxxx;Password=xxxxxxxx;";
Customer com = new Customer();
if (JO_NO != null)
{
StringBuilder sb = new StringBuilder();
using (OracleConnection con = new OracleConnection(st))
{
using (OracleCommand cmd = new OracleCommand("SELECT JO_QTY,JO_PRD FROM TABLE WHERE JO_NO='" + JO_NO + "'", con))
{
con.Open();
OracleDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
com.CustomerID = rdr["JO_PRD"].ToString();
com.FirstName = rdr["JO_QTY"].ToString();
sb.Append("
");
sb.Append("" + rdr["JO_QTY"].ToString() + "");
sb.Append("" + rdr["JO_PRD"].ToString() + "");
sb.Append("
");
res = sb.ToString();
}
}
}
}
}
return res;
}
public class Customer
{
public string CustomerID { get; set; }
public string FirstName { get; set; }
}

2 Replies

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

Francky Frined8y ago
Please help to write whole correct how to fetch server data using JSON format .
Laxmidhar Sahoo8y ago
1. $.ajax({
2. type: "POST",
3. contentType: "application/json; charset=utf-8",
4. url: "Fetch.aspx/GetData",
5. data: "{ JO_NO: '" + $('#Data').val() + "'}",
6. dataType: "json",
7. success: function (data) {
8. $("#DataDetails").html(data.d);
9. }
10. });
the below code should be changed
1. "{ JO_NO: '" + $('#Data').val() + "'}"
2. var sendingdata = { JO_NO: '" + $('#Data').val() + "'};
3. $.ajax({
4. type: "POST",
5. contentType: "application/json; charset=utf-8",
6. url: "Fetch.aspx/GetData",
7. data: JSON.stringfy(sendingdata),
8. dataType: "json",
9. success: function (data) {
10. $("#DataDetails").html(data.d);
11. }
12. });