ASP.NET

Vuyiswa Maseko wrote:

Meaning Populating the Listbox at run time ? Yes

Vuyiswa Maseko wrote:

On page load

devesh sinha wrote:

But yesterday what happened a user when saved his report, it was saved with other user's id.

SqlConnection con = cmn.getcon(); //new SqlConnection(constr);
               if (con.State == ConnectionState.Open)
                   con.Close();
               con.Open();
               SqlDateTime sqldatenull;
               sqldatenull = SqlDateTime.Null;
               SqlCommand cmd = new SqlCommand("usp_OrderMaster_Ins", con);
               cmd.CommandType = CommandType.StoredProcedure;

               string a = txtVisitHr1.Text.ToString();
               string b = txtVisitMin1.Text.ToString();

               // Define Parameters

               cmd.Parameters.Add("@VisitDate", SqlDbType.DateTime, 8).Value = cmn.MMDDYYtoYYMMDD(txtVisitDate1.Text);

               // --------------Stop After Discussion with Anand and G.Shyam Sundar -------------------------

               // cmd.Parameters.Add("@VisitTime", SqlDbType.DateTime, 8).Value = txtVisitHr1.Text.ToString() + ":" + txtVisitMin1.Text.ToString() + " " + ddlAMPM.SelectedValue.ToString();

               // -----------------------------------------------------------------------------------------

               cmd.Parameters.Add("@VisitType", SqlDbType.Char, 1).Value = ddlVisitType1.SelectedValue.ToString();
               cmd.Parameters.Add("@Usr_ID", SqlDbType.Int, 4).Value = Convert.ToInt32(usrid);
               cmd.Parameters.Add("@FinYr", SqlDbType.Char, 7).Value = cmn.FinYr();

               //change to session userid

               cmd.Parameters.Add("@OutledId", SqlDbType.Int, 4).Value = ddlPartner1.SelectedValue;

               int itmcnt = gdOrderDetails.Items.Count;

               string ordst = "";

               if (itmcnt > 0)
               {
                   ordst = "Y";
               }
               else
               {
                   ordst = "N";
               }

               cmd.Parameters.Add("@OrderStatus", SqlDbType.Char, 1).Value = ordst;

               if (txtNextVisitDt1.Text.ToString() == "")
               {
                   cmd.Parameters.Add("@NextVisitDate", SqlDbType.DateTime, 8).Value = sqldatenull;
               }
               else
               {
                   cmd.Parameters.Add("@NextVisitDate", SqlDbType.DateTime, 8).Value = cmn.MMDDYYtoYYMMDD(txtNextVisitDt1.Text.ToString());

               }

               // --------------Stop After Discussion with Anand and G.Shyam Sundar

               //if (txtNextVisitHr1.Text.ToString() == "")
               //{
               //    cmd.Parameters.Add("@NextVisitTime", SqlDbType.DateTime, 8).Value = sqldatenull;
               //}
               //else
               //{
               //    cmd.Parameters.Add("@NextVisitTime", SqlDbType.DateTime, 8).Value = txtNextVisitHr1.Text.ToString() + ":" + txtNextVisitMin1.Text.ToString() + " " + ddlNx.SelectedValue.ToString();
               //}

               //------------------------------------------------------------------

               cmd.Parameters.Add("@Expenses", SqlDbType.Money, 8).Value = "0";
               cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = txtRemarks1.Text.ToString();
               cmd.Parameters.Add("@SupplierID", SqlDbType.Int).Value = ddlSupplier.SelectedValue;

               if (txtDelDt1.Text.ToString() == "")
               {
                   cmd.Parameters.Add("@DeliveryDt", SqlDbType.DateTime, 8).Value = sqldatenull;
               }
               else
               {
                   cmd.Parameters.Add("@DeliveryDt", SqlDbType.DateTime, 8).Value = cmn.MMDDYYtoYYMMDD(txtDelDt1.Text);

               }
               cmd.ExecuteNonQuery();
               con.Close();
               Label1.Text = "Visit Details Saved....";
               Label1.Visible = true;
               Label1.UpdateAfterCallBack = true;
               ddlSupplier.Enabled = true;
               ddlSupplier.UpdateAfterCallBack = true;

       Session["Usr_Id"]="no";
Session["Section"] = "";

Response.ExpiresAbsolute = DateTime.Now;
          Session.Abandon();
          Response.Expires = 0;
          Response.Cache.SetNoStore();

          Session.RemoveAll();

devesh sinha wrote:

Logout Section:-
On logout user is redirected to homepage where on page load this code is written:

Session["Usr_Id"]="no";
Session["Section"] = "";

try
       {
           Session.Abandon();
           Response.Redirect("Home.aspx", false);

       }
       catch (Exception ex)
       {

       }

devesh sinha wrote:

what i think is the same session shared by two users.

devesh sinha wrote:

but while saving the data other user's id was passed.

devesh sinha wrote:

think it is beacuse of sharing of same session by two users and this thing happened for the first time after more than 1000 entries.

demetter wrote:

i have developed project in vb6.0,reporting tool crystal report 8,database ms access 2007.when executed program report was correct but converting report to .txt file inbetween line space is there.how can i remove that space