this can do it, but I dont advise ddCity.AutoPostBack = false; The reason why is this: When you select the item. It forces a postback before it fires the method. It runs your Page_Load, then runs your selected index somewhere in either events you are overriting the new value. You might be cahnging it from another event. For instance, in aither event you might be setting this value so its getting overidden. Put a breakpoint in the select changed value and then open the Debug --> Other windows --> Locals. Inspect the drop down list and check the value. Do this at post back. It should be fine. Although, looking at it. If you take out the entire if postback statement. It should work just fine. 1 line of code equals many bugs. So don't write any!!

Thanks!

That's the one, thanks!

Doesn't a VB command line app get passed the arguments collection ? Christian Graus - Microsoft MVP - C++

partt wrote: I save their login id as Public Shared partt wrote: when it is referenced later, it will grab the login id from someone else's session That is the correct behaviour - Public Shared mean that all instances of the class will share the same value so it should not be used for storing individual user IDs as a web application is a multi-user system and lots of users will be using it at the same time. partt wrote: Session("loginid"), it works ok for a while, then it loses it and goes to null That is most likely because the session has timed out. There is a setting in the web.config to make the session longer if you need to. The default is 20 minutes, so if the user does not interact with the web application for 20 minutes their session will end so that the server can free up resources to deal with users that are actually using the system. At this point the timed-out user will need to log in again. Does this help? Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

First, your question belongs in the ASP.NET Forum. Second, you can't do it using ASP.NET. ASP.NET only generates HTML that the browser can display. It has absolutely no control over the client. You'll have to come up with a JavaScript solution that the client can run itself. No, don't ask me for an example because I don't have one. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Hi Dave, according to your comment and my research, now I found a document from http://www.codeproject.com/vb/net/registry_with_vb.asp[^] about accessing the registry. This will speed up my project, Thank you a lot ;) A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

I tried this but it gives me an error: "Invalid Field Name" Dim crReportDocument As ReportDocument Dim crExportOptions As ExportOptions Dim crDiskFileDestinationOptions As DiskFileDestinationOptions Dim Fname As String crReportDocument = New ReportDocument() crReportDocument.Load("destination to .rpt") Dim logonInfo As New TableLogOnInfo() Dim i As Integer For i = 0 To crReportDocument.Database.Tables.Count - 1 logonInfo.ConnectionInfo.ServerName = "servername" logonInfo.ConnectionInfo.DatabaseName = "DBname" logonInfo.ConnectionInfo.UserID = "userID" logonInfo.ConnectionInfo.Password = "passWord" crReportDocument.Database.Tables.Item(i).ApplyLogOnInfo(logonInfo) Next Dim discreteParam As New ParameterDiscreteValue() Dim paramField As ParameterFieldDefinition Dim defaultValue As ParameterValues paramField = crReportDocument.DataDefinition.ParameterFields.Item("SexID") discreteParam.Value = txtGender.Text.Trim defaultValue = paramField.DefaultValues defaultValue.Add(discreteParam) paramField.ApplyCurrentValues(defaultValue) paramField = crReportDocument.DataDefinition.ParameterFields.Item("RaceID") discreteParam.Value = txtRace.Text.Trim defaultValue = paramField.DefaultValues defaultValue.Add(discreteParam) paramField.ApplyCurrentValues(defaultValue) paramField = crReportDocument.DataDefinition.ParameterFields.Item("LBirth") discreteParam.Value = lblUpDOB.Text defaultValue = paramField.DefaultValues defaultValue.Add(discreteParam) paramField.ApplyCurrentValues(defaultValue) paramField = crReportDocument.DataDefinition.ParameterFields.Item("UBirth") discreteParam.Value = lblLowDOB.Text defaultValue = paramField.DefaultValues defaultValue.Add(discreteParam) paramField.ApplyCurrentValues(defaultValue) paramField = crReportDocument.DataDefinition.ParameterFields.Item("SiteID") discreteParam.Value = ddlSite.SelectedItem.Value defaultValue = paramField.DefaultValues defaultValue.Add(discreteParam) paramField.ApplyCurrentValues(defaultValue) Dim tDay As Integer Dim tCall As Integer Dim DD As DateTime 'Date that is X amount of days in the past decided by txtPast Dim CallActi

What CrystalReports is writing to your file is not a valid .PDF format. The version of CrystalReports that comes with Visual Studio, apparently, doesn't support .PDF. It looks like you'll have to upgrade to the full version of CR from BusinessObjects.com. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Oops, ok, problem solved. Thank you.

That stuff you emailed me looks much cleaner, thank you. I'm having trouble with the connection string though: oConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=TempExcel;Data Source=JETSTREAM" I have a windows auth to connect, in other words, I don't need to enter username or password to get in. I'm not sure how to adjust this. Also, in "SELECT * FROM TheTable", what is TheTable? Is it some name from the .xls somehow? Thank you for your patience.

Thank you for your help!

Hope the following query would help select distinct UC.GeneralDescription GeneralDescription, case when TU.TesterID is null then 'False' else 'True' end As There from tUConsumer UC inner join tLuUsage LU on UC.CMCode = LU.UsageIndex left join tTesterUsage TU on TU.UsageID = LU.UsageID and TU.TesterID = @testerID

Try something like: --Create temp table containing all possible descriptions. select distinct Desc into #temp01 from YourTable --Use outer join to pull list of all descriptions, then cross-match --with person attributes. If the person does not have a matching --attribute then the YT.Desc value will be null. The "case" --statement outputs true/false appropriately. select T1.Desc, case when YT.Desc is null then 'True' else false end There from #temp01 T1 left outer join YourTable YT on YT.PersonId = 856 and YT.Desc = T1.Desc order by 1 You can do this without using the temporary table if you wanted (just replace #temp01 in the second query with "(select distinct Desc from YourTable)" to create an in-line view. Andy