Hi
I have Web Services that get all data from SQL server and I create HTML table to dispaly all data using Jqurry Ajax but I have problem with ajax. can any one help me
JQuery
$(document).ready(function () {
$("#contant_hr").append('<table id="ResultsTable" class="DepartmentTable"><tr><th>Department ID</th><th>Name</th><th>Group Name</th><th>Modified Date</th></tr>');
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Department_Service.asmx/GetAllDepartments",
dataType: "json",
success: function (msg) {
alert('DFGFD');
var c = eval(msg.d);
for (var i in c) {
$("#ResultsTable tr:last").after("<tr><td>" + c[i][0] + "</td><td>" + c[i][1] + "</td><td>" + "</td><td>" + c[i][2] + "</td><td>" + c[i][3] + "</td></tr>");
}
}
});
});
WebService
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string GetAllDepartments() {
SqlConnection conn = new SqlConnection(“Data Source=ABDALLA-HP\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True;”);
string sqlstring = "SELECT DepartmentID, Name, GroupName, ModifiedDate FROM HumanResources.Department";
SqlCommand comm = new SqlCommand(sqlstring,conn);
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(comm);
adapter.Fill(dataset, "reading");
conn.Close();
//creating Array
string[][] jaggedArray = new string[dataset.Tables[0].Rows.Count][];
int i = 0;
foreach (DataRow rs in dataset.Tables[0].Rows)
{
jaggedArray[i] = new string[] { rs["DepartmentID"].ToString(), rs["Name"].ToString(), rs["GroupName"].ToString(), rs["ModifiedDate"].ToString() };
i = i + 1;
}
//return JSOM data
JavaScriptSerializer js = new JavaScriptSerializer();
string strJSON = js.Serialize(jaggedArray);
return strJSON;
}