Have you tried debugging your code? Have you checked the values being passed to your query? Are you getting errors?
As a side note, please make it a habit to use the using statement when dealing with objects that eat resources such as SqlConnection and SqlCommand to ensure that the object will be properly closed and disposed after you use them.
Finally, place your connectionString within your config file so you can easily switch and modify the settings when needed without compiling your code.
At least one visible problem seems to be that you have mispelled the @level4 parameter. In the insert statement you have @level14 but in the parameters you have @level4 (without 1). That should cause an exception in your code.
In overall you seem to be missing few elemental parts
- You don't have any error handling
- you don't dispose objects etc.
I want to create a toggle switch where the user has the choice of Purchase or Delivery. I've seen the Yes/No and True/False type of toggle switches but has anyone seen or have a way of creating a toggle switch with a that many letters.
In a web form 2010 application, I am creating letters that need to be sent to various customers that are generated in html and are sent to 2 or 3 customers at the at different addresses. However each letter needs to be the same. The only difference is the mailing address. Thus I need each letter to be generated on separate pages. Thus I would like to know what html command can be used to made certain each letter is printed on separate pages. Thus can you tell me what the command would be?
It seem like you've not even googled the slightest info available to you but this should help.
If your web app is reatricted to your country then search for an sms campany that offers this service at a cheap and steady rate, they will provide an api to allow you work with your app platform, java, asp.net, perl etc as the case may be.
Follow the provided samples and integrate with your app.
If its an international target then look for a company that can serve you well with speed and server uptime.
For the life of me I can't understand why my grid won't populate. I'm sending my data from the controller to the view but the grid is always blank.
public JsonResult PopulateGrid()
var x = (from n in dbContext1.GetOrders("Melody Devoe") select n);
List<string> items = new List<string>();
foreach (var item in x)
//List<CentralBilling.Models.GetOrders_Result> returnList = new List<CentralBilling.Models.GetOrders_Result>();return Json(items.ToList(), JsonRequestBehavior.AllowGet);