jquick

Is that not what a SELECT / SWITCH / CASE statement is for? It essentially does the same thing. Btw that was a stupid answer iamthwee :P Jenni

I think a code sample would help diagnose the problem a bit better. Is the Rectangle a table or something? Do you expect data is those two missing columns? You may wanna to provde some more info. jenni

Change your code to this: strSQL = "select top 10 from tbl_Transactions where Account_Number='" & UserAccGlobal_Login & "'"

Hi, To answer your first question - from your code sample below the way you are doing data access is pretty bad practice. For one - opening a connection at all is an expensive operation, so doing it consecutively should be avoided, especially when you can get all that data …

Yep you are right. That is a little quirk in the Mozilla XMLHTTP object. You should really be using some kind of library to perform your asynchronous javascript calls. JQUERY makes it super easy and is compatible with all broswers. [url]http://jquery.com/[/url] jenni

Hi, That is a pretty vauge question. The best way to get started with data access in .net is to use the Microsoft Data Access Application blocks: [url]http://www.microsoft.com/downloads/details.aspx?FamilyId=F63D1F0A-9877-4A7B-88EC-0426B48DF275&displaylang=en[/url] Once you download and add these to your app you can perform data access on a access database like this: [Code=C#] public …

Hi, I need to build a datetime object out of 3 drop down lists. I know I can use DateTime.TryParse().. but I don't know what format it wants? I tried this: [CODE=C#] showDate. = Convert.ToInt32(ddl_bday_day.SelectedValue); showDate.Month = Convert.ToInt32(ddl_bday_month.SelectedValue); showDate.Year = Convert.ToInt32(ddl_bday_year.SelectedValue); [/CODE] But those are read only properties. I then …