In Html
<div id="div_id"></div>
In Jquery code JqueryDatabind.js
$.fn.DataBind = function () {
var data = "{}";
var url = "Testing.aspx/get_data";
$(this).AjaxPOST(url, data, function (d) {
if (typeof (d[0]) !== 'undefined') {
$('#div_id').append(d[0].id.toString());
}
});
}
In Web Services Code
public class DataId
{
public string id;
}
[WebMethod]
public List<DataId> get_data()
{
List<DataId> dataid= new List<DataId>();
string query = "";
try
{
// pass your Sql connectionstring Web.config
SqlConnection con = new SqlConnection(Pass Your ConnectionString );
con.Open();
query = "select dataid From YourTableName";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count>0)
{
DataListId data_list = new DataListId();
data_list.id= ds.Tables[0].Rows[0]["dataid"].ToString();
dataid.Add(data_list);
}
con.Close();
}
catch (Exception ex)
{
}
return dataid;
}
No comments:
Post a Comment