public static void MyMethod(string pname, string itemid, string q, string a) { try { //Do here server event //string item_name = pname; string item_name = pname; item_name = item_name.TrimEnd(','); string[] _itemname = item_name.Split(','); string item_id = itemid; item_id = item_id.TrimEnd(','); string[] _productId = item_id.Split(','); System.Web.HttpContext.Current.Session.Add("item_id", _productId); string quantity = q; quantity = quantity.TrimEnd(','); string[] _quantity = quantity.Split(','); System.Web.HttpContext.Current.Session.Add("quantity", quantity); string amount = a; amount = amount.TrimEnd(','); string[] _amount = amount.Split(','); string query = ""; for (int i = 0; i < _itemname.Length; i++) { query = "insert into tblCart values('" + _productId[i] + "','" + _quantity[i] + "','" + System.Web.HttpContext.Current.Session["userId"] + "')"; con.ExecuteQry(query); } } catch (Exception) { throw; } }
protected void btnSubmit_Click(object sender, EventArgs e) { lblMessage.Visible = false; string query = "select count(*) from tblRegisteration where EmailId = '" + txtEmail.Text + "'"; string res = c1.SelectScalar(query); if (int.Parse(res) == 0) { query = "insert into tblRegisteration(FirstName,LastName,EmailId,Password,MobileNo)values('" + txtFirst.Text + "','" + txtSecond.Text + "','" + txtEmail.Text + "','" + txtCPassword.Text + "','" + txtMobile.Text + "')"; c1.ExecuteQry(query); Response.Redirect("ConfirmRegistration.aspx"); } else { lblMessage.Visible = true; } }