digsy_ wrote: Is there a way to omit the first line in the schema or just specify the filename as *.csv ? I've never used the Text driver, so.... As far as I can tell, no you can't remove this. You are probably going to have to write this file out with the name of the file you're importing for each and every file you import using this method. The alternative is to write your own import implentation from scratch or try to find a third party CSV parser class. Search the articles here for "CSV" and you should find at least one. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

I'll try that - the next field in the csv row has exactly the same types of data in it and doesnt have any problems being saved to the database

id<=c1.id add one more condition (id<=c1.id) to the subquery which Dupes column will generate a sequence num for the subsequent duplicate records. All Dupes with value (1) should be considered as first occurance and rest Dupes value with 2, 3, 4... are 2,3,4... occurances Not sure. just check Regards John

Yes, You can do it. There are various method available but the simplest way is to use 'cookies':), like this, ' on "Login.aspx.vb" page Dim uname As String = Login1.UserName Dim pwd As String = Login1.Password e.Authenticated= FormsAuthentication.Authenticate(uname,pwd) If FormsAuthentication.Authenticate(uname, pwd) Then FormsAuthentication.RedirectFromLoginPage(uname, True) Response.Cookies("CokieLogin").Value = uname Else Login1.FailureText = "Either User Name or Password is wrong." End If 'On "Default.aspx.vb" page Dim UserName As String = UCase(Request.Cookies("CokieLogin").Value) 'here we expire the cookies Response.Cookies("CokieLogin").Expires = System.DateTime.Now() prabhakar

Assuming you are using .NET Framework v2.0 or later, you can use the Int32.TryParse(String, NumberStyles, IFormatProvider, Int32) method[^]. For the NumberStyles parameter, you probably want to use NumberStyles.Currency. ----------------------------- In just two days, tomorrow will be yesterday.

You work on a farm! Gosh! You find Software Developers in every corner of society. :-D Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Use ViewState, e.g. ViewState("something") = something; This is 'encrypted' and hidden from the user on the page.

OK - I meant MS Atlas.

No need for HYperlink. It will work fine. Regards, Satips.

I'd recommend Ajax Control Tookit for that special need. http://ajax.asp.net/ajaxtoolkit/HoverMenu/HoverMenu.aspx[^]

Short circuiting simply refers to the case where a boolean condition halts before it evaluates the next part. A simple C# demonstration should show this: DateTime? dtToday = null; if (dtToday == null || dtToday == DateTime.Now) The second part never executes because dtToday is null and so the conditions for an or statement is satisfied. In the case of an AND condition, the second part of the statement would not be executed if the first part is false. Deja View - the feeling that you've seen this post before.

When you are adding a datetime value of any sort to a database leave it in a date, I mean DATE, format if possible. Otherwise you must format it correctly to insert. So ensure that the value you are parsing to DateTime is a date value and dont set it to short date string. SmallDateTime is about precision not how it looks in the DB[^] CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)