title: How to execute sql server stored procedure by using json?
body: <p>Iam creating form for point of sale for resturaunt management system in Asp.net,I have two section one is
  Category like which have buttons like Drinks,Pizza etc and 2nd section is of Item which are sub menus of Category like if you click on Drink it should open sub menus Pepsi,Coke,Mirinda etc from sql server table.</p>
  
  <p>i have created run time buttons of category,now i want to use json to execute stored procedure
  to show sub menus in item on the click of category
  Buttons.please explain the process of connectivity
  with sql server and to execute stored procedure 
  by using json.Thanks in Advance.
  Regards saqib</p>