I am working with asp.net webmethed i want get a return value and set it to text box
<asp:TextBox ID="TxtSearch" runat="server" placeholder="Search Order" Width="150px"></asp:TextBox>
<input type="submit" name="btn_search" id="btn_search" value="Search">
when i am clicking in submit button it goes to webmethod but i am not unable to get data from it and set it to text box
<asp:TextBox ID="TxtOrder" runat="server" Width="150px"></asp:TextBox>
My Method is given below
[WebMethod]
public static List<Search> Search_Order(string TxtSearch)
{
db_class Connstring = new db_class();
try
{
DataTable dt = new DataTable();
List<Search> SearchItem = new List<Search>();
dt = Connstring.SqlDataTable(@"SELECT OrderNo, Date, CustomerName, ProductID, Price, Total, Quantity, Product_Name FROM Order_Details WHERE OrderNo='" + TxtSearch + "'");
foreach (DataRow dtrow in dt.Rows)
{
Search SearchDeatils = new Search();
SearchDeatils.Product_Name = dtrow["Date"].ToString();
SearchDeatils.ProductID = dtrow["CustomerName"].ToString();
SearchDeatils.Product_Name = dtrow["OrderNo"].ToString();
SearchItem.Add(SearchDeatils);
}
return SearchItem;
}
catch (Exception)
{
throw;
}
}
public class Search //For Order search
{
public string Date { get; set; }
public string CustomerName { get; set; }
public string OrderNo { get; set; }
public string ProductID { get; set; }
public string Price { get; set; }
public string Total { get; set; }
public string Quantity { get; set; }
public string Product_Name { get; set; }
}
And script is
$(window).load(function () {
$("#btn_search").live('click', function () {
$.ajax(
{
type: "POST",
url: "MasterDetails.aspx/Search_Order",
data: "{TxtSearch: '" + $('#TxtSearch').val() + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (Result) {
alert('Get Data from DB');
$.each(Result.d, function ()
{
document.getElementById('#TxtOrder').value = value.OrderNo;
});
}
});
});
});