Inventory Management: On hand quantity (vb.net or C#)

Question

1.00/5 (1 vote)

See more:

I am trying to migrate from Microsoft Access to an online asp.net website for my inventory management database.

In Microsoft Access I used Allen Browne's solution for inventory management: http://allenbrowne.com/appinventory.html and it works great for my needs but MS Access doesn't.

I have very basic knowledge in Visual Studio (I'm working mostly in Design Mode). Is there any similar solution, for Allen Browne function, that I can use to calculate on hand quantity of my inventory in visual studio?

Is there any way I can convert the vba function to C# or VB, or any way I can use it from the MS Access Module? (besides learning C# or VB from scratch and make my own function)

*Note: I haven't started the project yet so it does not matter if the solution is in C# or VB.net I don't know any of them so I will work mostly in design mode.

Thank you.

Posted 12-Oct-15 5:26am

Member 12052712

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Oct-15 11:36am

If you are mostly using design mode, you are not doing any serious programming; it cannot last forever. There is no an "automatic" way to convert from VBA, because it works on a very different platforms which does not have correspondence with .NET, in contrast to translations between C# and VB.NET which can easily be done automatically. Your settings description is very unclear. Say, you cannot say "migrate from Access to website", because access is a database tool (a kind of :-), and Web site is Web site...
—SA

F-ES Sitecore 12-Oct-15 11:41am

If you wanted something close to a conversion then you could write that code that generates the SQL in your asp.net forms and use ado.net to execute the SQL rather than using OpenRecordset. Or you could actually spend time to understand what is happening and convert the code to Stored Procedures instead, or look to implement the logic using Entity Framework. Either way it's going to involve learning *something*, as has already been said there is no one-to-one conversion between this code and webforms+sql

Maciej Los 12-Oct-15 11:43am

This is not a real question!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-10-12T05:41:00

To be honest, if you don't know either of them, then the first thing you need to do is learn one! You can't "work mostly in design mode" for VB or C# - they are general purpose languages and need you to be able to code in order to get the "design mode" stuff to actually do anything. And to do that, you need to know how to access databases, and what to do with controls. If you are truly moving to an online website for this, then you have even more to learn - the way websites work (which is nothing like an Access app) and probably some Javascript as well to handle the client side stuff. If you don't, you are going to end up with a very slow, awkward, and unresponsive solution.

I'd stop and think long and hard if you are giving yourself a task that you are very unprepared for.