protected void Page_Load(object sender, EventArgs e) { string jsonResult = string.Empty; DALClass dalClass = new DALClass(); try { string strProductNo = Request["strProductNo"]; DataTable dtProduct = dalClass.GetProductByNo(strProductNo); if (dtProduct != null && dtProduct.Rows.Count > 0) { string strProductName = string.Empty; string strProductColor = string.Empty; string strProductSize = string.Empty; string strProductPrice = string.Empty; string strProductId = string.Empty; if (!(dtProduct.Rows[0]["ProductName"] is DBNull)) { strProductName = dtProduct.Rows[0]["ProductName"].ToString(); } if (!(dtProduct.Rows[0]["ProductColor"] is DBNull)) { strProductColor = dtProduct.Rows[0]["ProductColor"].ToString(); } if (!(dtProduct.Rows[0]["ProductSize"] is DBNull)) { strProductSize = dtProduct.Rows[0]["ProductSize"].ToString(); } if (!(dtProduct.Rows[0]["ProductPrice"] is DBNull)) { strProductPrice = dtProduct.Rows[0]["ProductPrice"].ToString(); } if (!(dtProduct.Rows[0]["ProductId"] is DBNull)) { strProductId = dtProduct.Rows[0]["ProductId"].ToString(); } jsonResult = "{\"Product\":" + "[" + "{\"ProductName\":\"" + strProductName + "\",\"ProductColor\":\"" + strProductColor + "\"," + "\"ProductSize\":\"" + strProductSize + "\"," + "\"ProductPrice\":\"" + strProductPrice + "\"," + "\"ProductId\":\"" + strProductId + "\"}" + "]" + "}"; } } catch (Exception ex) { throw ex; } Response.Write(jsonResult); Response.End(); }
/// <summary> /// Binds the data of the salesman to DropDownList control. /// </summary> private void BindSalesman() { dpd_SalesMan.Items.Clear(); DALClass dalClass = new DALClass(); DataTable dtSalesMan = dalClass.GetSalesMan(); if (dtSalesMan != null && dtSalesMan.Rows.Count > 0) { dpd_SalesMan.DataSource = dtSalesMan; dpd_SalesMan.DataValueField = "SalesManId"; dpd_SalesMan.DataTextField = "SalesManName"; dpd_SalesMan.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { string jsonResult = string.Empty; DALClass dalClass = new DALClass(); try { string strCustomerName = Request["strCustomerName"]; DataTable dtCustomer = dalClass.GetCustomerByName(strCustomerName); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { string strAddress = string.Empty; string strTelePhone = string.Empty; if (!(dtCustomer.Rows[0]["CustomerAddress"] is DBNull)) { strAddress = dtCustomer.Rows[0]["CustomerAddress"].ToString(); } if (!(dtCustomer.Rows[0]["CustomerTelePhone"] is DBNull)) { strTelePhone = dtCustomer.Rows[0]["CustomerTelePhone"].ToString(); } jsonResult = "{\"Customer\":" + "[" + "{\"Address\":\"" + strAddress + "\",\"TelePhone\":\"" + strTelePhone + "\"}" + "]" + "}"; } } catch (Exception ex) { throw ex; } Response.Write(jsonResult); Response.End(); }