Hello,

I have been working on my first module, and this is one in which will not be for resale, and will not leave my building, as they are tailored to interact with our phone system, to get a phone extension list, and with our payroll system to build a staff listing (i.e. address/phone/job title/department). They are very much tailored to our building.

I created a module template, and when in the View.ascx.vb I removed all the code from lstContent_ItemDataBound. This is where I was putting all my code.  This worked, as all I am doing is readnig from a database, and putting the data out, in a gridview or repeater. So this all works fine.

But in doing this, I have a few questions. I stored my MSSQL connection in the web.config, Is this the best place to put it? Next, is there a better place to put my code than lstContent_ItemDataBound ? I'm unsure even WHY this sub routine is being executed, as I dont see it being called, and I dont see anything in the ascx file named lstContent. And the last quesiton is this. I need a dropdown box, that when an item is selected, the page refreshes and the query's Where Lastname LIKE @Selection is updated, showing only those with i.e. last name of 'Doe'. Well, I modified my SQL query to accept this, and I setup some Command.Paramters.Add and similar things. THe problem that I get is that, for some reason, when I make a selection with my dropdown box, with autopostback=true, the value I select isnt 'sticking'. What i mean by that, is when the page refreshes, it goes back to the first item, as I dont have a default set. This to me, seems like no view state is 'alive'. How can I fix this?

Thanks!