asked on

Inventory System project in ASP.NET - I've never used ASP before

Hi,

I need to redo our inventory system from VB.NET to ASP.NET. I've never used ASP or ASP.NET, so I'm a little worried and confused. For instance, I see I can start a VB project and have it be ASP.NET web application or ASP.NET web service. What would an inventory system be? Basically just several forms that interact with different tables in our SQL Server database. The point is to have our inventory system, which so far has been a standalone application, work from within Internet Explorer on our intranet.

Any startout hints, help, links, etc would be appreciated.

JP

SOLUTION

boblah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

nauman_ahmed

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gleznov

ASKER

Also, eventually I want to allow our company's handheld units to interact with the system. Do I need to start designing using the ASP.NET Mobile, or will that be a separate application for only the handhelds? Someone I work with said it would display normal for normal computers but allow a different smaller interface for handhelds? Or do I need to make one program for normal computers (ASP.NET web application) and the handheld will be something entirely separate?

JP

nauman_ahmed

You can use ASP.Net Mobile Controls for this purpose. But first build the ASP.Net application and once it starts working as you have planned, go for the next phase and develop the application to be accessoble by handhelds.

Best, nauman.

gleznov

ASKER

So should I still start our with a VB ASP.NET web application, or use a VB ASP.NET mobile web application for the whole thing?

Also, here's code I use in windows forms:
Dim da As New SqlClient.SqlDataAdapter("select * from supplies order by ID", SqlConnection1)
da.Fill(DataSet_JPTest1, "supplies")

This fills a dataset with all info from supplies. I added the adapter and created the dataset the same, but this code isn't working - I get:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I haven't had to use any form of authentication using that SQL Server database from my windows forms application - what's the difference?

JP

boblah

gleznov,

Yes, start with a simple VB ASP.NET web application first.

Your vb application authenticates to the database using the credentials of the user that is logged into the machine.

Your ASP.NET application uses the Internet Guest Account (assuming you haven't set up any authentication).

This is user name IUSR_<machine name>, and has heavily restricted permissions. You should think twice before allowing it permissions on your database.

Configuration of authentication etc is another question's worth.

gleznov

ASKER

Actually we have that book upstairs (MCAD/MCSD Developing Web Applications w/ VB.NET and C#.NET) and it looks perfect - I'll take this three day weekend to take in as much of this book as possible. Thanks everyone!

JP