i want to insert Session ID of user into table ,
- if (Session["EmpID"] == null)
- {
- Response.Redirect("LogingForm.aspx");
- }
- protected void tbsv_Click(object sender, EventArgs e)
- {
- {
- {
- if (ddlBbitem.SelectedValue == "")
- {
- Response.Write("");
- }
- else
- if (prdbqty.Text == "")
- {
- Response.Write("");
- }
- else
- {
- con.Open();
- SqlCommand cmd = new SqlCommand("spInsertbigbale", con);
- cmd.CommandType = CommandType.StoredProcedure;
- // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
- cmd.Parameters.AddWithValue("@Codeitem", ddlBbitem.SelectedValue);
- cmd.Parameters.AddWithValue("@Bweight", prdbqty.Text.Trim());
- cmd.Parameters.AddWithValue("@Bpqty", opbbqty.Text.Trim());
- cmd.Parameters.AddWithValue("@CID", DDLBBCID.SelectedValue);
- cmd.Parameters.AddWithValue("@SecID", DDLBBsec.SelectedValue);
- cmd.Parameters.AddWithValue("@EntryDate", txtbpentrydate.Text);
- cmd.Parameters.Add("@BID", SqlDbType.Int);
- cmd.Parameters["@BID"].Direction = ParameterDirection.Output;
- cmd.ExecuteNonQuery();
- int ResultValue = Convert.ToInt32(cmd.Parameters["@BID"].Value);
- if (ResultValue > 1)
- {
- Response.Redirect("BigBalePrintView.aspx?BID=" + ResultValue + "");
- }
- else
- {
- Response.Write("");
- }
- con.Close();
- }
- }
- }
Priyanka JainPosted Jul 17, 2019, 4:50 AM
Adam HenryPosted Jul 22, 2019, 1:17 AM
Akhter HUssainPosted Jul 17, 2019, 4:20 AM
Sivakumar Koneti
Sivakumar KonetiPosted Jul 17, 2019, 4:13 AM
Akhter HUssainPosted Jul 17, 2019, 4:07 AM