ASP.NET

Vuyiswa Maseko wrote:

ds = obj.FILTER_TAG(Selected_Staff, Convert.ToString(Session["ActiveDatabase"]));

//Binding the Listboxes

ListBox1.DataSource = ds;

Vuyiswa Maseko wrote:

ListBox1.DataTextField = "Descr";

//Binding the Listboxes
       if (ds.Tables[0].Rows.Count > 0)
       {

           ListBox1.DataSource = ds;

           ListBox1.DataTextField = "Descr";

           ListBox1.Visible = true;

           lstbxLecturers.Visible = false;

           ListBox1.DataBind();
       }
       else
       {

           //Leave it there Way it is
           ListBox1.Visible = false;

           lstbxLecturers.Visible = true;
       }

private void Bind_Tags_List()
  {


      //Bind the listbox that Contains the Tags
      BLL.BLL obj = new BLL.BLL();

      String DB = Convert.ToString(Session["ActiveDatabase"]);

      try
      {

          DataSet ds = obj.Get_Tag_Staff_Only(DB);

          lstbxTags.DataSource = ds;

          lstbxTags.DataTextField = "DESCR";

          lstbxTags.DataBind();


      }
      catch (SqlException ex)
      {
          lblAdminStatus.Text = ex.Message.ToString();
      }
  }

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)
       {

       }