protected void Page_Load(object sender, EventArgs e) { NorwinDBTableAdapters.ProductsTableAdapter products = new NorwinDBTableAdapters.ProductsTableAdapter(); //get the product Id from the query string prodID = int.Parse(Request.QueryString[0]); //get the other needed info from various queries //TODO get this from the logged in account custID = "GROSR"; prodName = products.GetNameByProdID(prodID).ToString(); //use the product id to call my scalar SQL statement to get the number of units in stock unitsInStock = Convert.ToInt32(products.GetInStockByProdID(prodID)); if (unitsInStock > 0) { //set the max value of the validator to be the amount thats in stock vldQuantity.MaximumValue = unitsInStock.ToString(); } else { vldQuantity.MinimumValue = "0"; vldQuantity.MaximumValue = "0"; } lsvProdDetails.DataSource = products.GetDataByProdID(Convert.ToInt32(Request.QueryString[0])); lsvProdDetails.DataBind(); }