A little history about me real quick.. I have several years of VB 5.0 and v6.0 expereince. I took a break from coding for awhile and took a job as a Oracle DBA. I was only creating PL/SQL scripts It was ok, but after 4 years I came back to development again. 2 weeks ago, I just started a new job. The job has a ton of Access 2003 DB's they want converted to SQL Server with .NET frontend. Some of the DB's will nned to have a web frontend also so users use input their data into the db from the web.
Ok... sorry for the long winded background on me and this job, just trying to give a little background and let you all know I am not fresh out of college.
The developer before me created a webpage one of the DB's. The page was not connecting to a DB, it was creating a text(Comma delimited),the text file would then get ftp'd to the server where the Access DB lived, the text file would get uploaded uploaded to the DB everyday. Don't asked me why they did this, it had to do with government security issue, etc... So I have been reviewing the last developers code, in the page. He used Frontpage to create it. The page uses Java Script for validation.
My question is: I know I need to use ASP.NET to make a connection string to the DB to write directly to the DB. I suggested we do all the paperwork the government wants and cut out the ftp stuff and writing to the text file and write directly from the web form to the DB. So if I go in and start coding in ASP.NET with a html page that has java script, do I just change the extention of the file to aspx? Can you have ASP code and Java Script? Would it be better to do the validation in VB script?
Sorry for the "TO MUCH INFO"... usually when I post, some people will end up asking me a ton of questions post I didn't post enough history, hopefully I posted enough this time.
Also, I am new to web development and .NET. I have a little experience in ASP but not ASP.NET.