ASP.NET

9-Apr-09 0:02

Good Day All

I have a Listbox with name lstbxTags and it get populated fine and i have another two List boxes named ListBox1 and lstbxLecturers in lstbxTags_SelectedIndexChanged event of the Listbox lstbxTags i have the Following Code

protected void lstbxTags_SelectedIndexChanged(object sender, EventArgs e)
 {
     //This Session Variable will Hold the ID of the selected Staff

     BLL.BLL obj = new BLL.BLL();

     DataSet ds = new DataSet();

     String SelectedStaff = Convert.ToString(lstbxTags.SelectedItem.Value);

     //Assign the returned id to the Session variable
     int Selected_Staff = obj.Get_Selected_id_of_Tag(SelectedStaff, Convert.ToString(Session["ActiveDatabase"]));

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

     //Binding the Listboxes

     ListBox1.DataSource = ds;

     ListBox1.DataTextField = "Descr";

     ListBox1.Visible = true;

     lstbxLecturers.Visible = false;

     ListBox1.DataBind();


 }

Now when i select something in the lstbxTags, nothing gets Populated in ListBox1, i have step through the code and it goes without a Problem.

what is the Problem

Thanks

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

monu nair9-Apr-09 0:06

monu nair

9-Apr-09 0:06

what is your Requirement.

Mahendra Bisht.

Vimalsoft(Pty) Ltd9-Apr-09 0:09

9-Apr-09 0:09

My Problem is that the Listbox1 does not Get Populated with the values when you select an Item in lstbxTags listbox

Vimalsoft(Pty) Ltd9-Apr-09 0:15

9-Apr-09 0:15

I even Added the Following Code at the End

//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;
       }

this is to test if there are any records returned and the First true to the If statement get executed.

Thank you

Abhijit Jana9-Apr-09 0:17

9-Apr-09 0:17

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

//Binding the Listboxes

ListBox1.DataSource = ds;

Does Ds populating correctly?

Vuyiswa Maseko wrote:
ListBox1.DataTextField = "Descr";

What about the data text field ?

I have done a small prototype with ArrayList and bind the data, its working fine.

cheers,
Abhijit
CodeProject MVP

Vimalsoft(Pty) Ltd9-Apr-09 0:29

9-Apr-09 0:29

This has been Working. So for the sake of look and feel , i too these controls and Put them in an Update Panel and Add them to a table, after i did that it stopped working. the "Descr" is Correct. as i said i tried to check if the returned Dataset has records by doing this

//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;
       }

And when i debug this , it says there are records, but i cant understand why dont they get populated in ListBox1

Thanks

Abhijit Jana9-Apr-09 1:22

9-Apr-09 1:22

No Luck ! I didn't find issue with that, even I have tried with Dataset Frown | :(

Are you generating the list box at runtime ?

cheers,
Abhijit
CodeProject MVP

Vimalsoft(Pty) Ltd9-Apr-09 1:27

9-Apr-09 1:27

Meaning Populating the Listbox at run time ? Yes

like this

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();
      }
  }

On page load

Thanks

Abhijit Jana9-Apr-09 1:59

9-Apr-09 1:59

Vuyiswa Maseko wrote:
Meaning Populating the Listbox at run time ? Yes

I want to mean creating the List Box Control ? Are you creating the Listbox at runtime ?

Vuyiswa Maseko wrote:
On page load

cheers,
Abhijit
CodeProject MVP

Vimalsoft(Pty) Ltd9-Apr-09 2:06

9-Apr-09 2:06

No am not creating the Listbox control at runtime , but populating it at Runtime. I have Notice something String. When i select Something from the lstbxTags nothing get Displayed in the ListBox1 and when i select other Control that has no code in it in my page like a button , the ListBox1 gets Populated.

Vimalsoft(Pty) Ltd9-Apr-09 3:56

9-Apr-09 3:56

I found the Problem; the Problem is that one of my Listboxes had a Autopostback property to False. I can’t believe that I spent the whole day trying to solve this problem and change my code, but still. I think this is one of those days

Thank you for your Help

Abhijit Jana9-Apr-09 4:24

9-Apr-09 4:24

cheers,
Abhijit
CodeProject MVP

monu nair9-Apr-09 0:33

monu nair

9-Apr-09 0:33

use the following line

ListBox1.Items.Add(lstbxTags.SelectedItem);

Mahendra Bisht.

Vimalsoft(Pty) Ltd9-Apr-09 0:38

9-Apr-09 0:38

That will Work but in my case, after selecting a Value from the lstbxTags i got to the database and look for it ID , and from that , another SP is Called that will retrieve the Records based on that ID. So this is like a Filter thing. So a User will save a Filter tag with some records. Now i will be Displaying records based on that Filter

Thank you

monu nair9-Apr-09 0:41

monu nair

9-Apr-09 0:41

so your question solved now or not.

Mahendra Bisht.

Vimalsoft(Pty) Ltd9-Apr-09 1:23