View previous topic :: View next topic |
Author |
Message |
asianking Expert Cheater
Reputation: 0
Joined: 25 Jun 2008 Posts: 109
|
Posted: Fri Mar 04, 2011 4:15 pm Post subject: MS Access + VB coding (Need help setup) |
|
|
Here is a diagram I draw.
My goal: Use this as task checklist database. I know there's already a template, but not a checklist typo.
explaination:
Save: Save as new user. If user already exist; Reject save and tell user that it already exist so use Update button instead.
Update: Update existed data information with a warning are you sure incase of accident.
Search: search by either Name, Tag, or Service Tag. Doesn't have to fill-in all info here. Can just type the user name and search or etc...
Checklist: task such as install flash, install office, etc...
Checkbox: Uncheck as default and able to check it if task is done.
I like this to be more like a database type.[/img]
_________________
|
|
Back to top |
|
 |
AhMunRa Grandmaster Cheater Supreme
Reputation: 27
Joined: 06 Aug 2010 Posts: 1117
|
Posted: Fri Mar 04, 2011 11:25 pm Post subject: |
|
|
I would use asp and C# for this rather than VB. You can even put it inside a pretty page and either update it per event like click a check box the db updates instantly or wait until completion to update the form. You can use the ODBC adapter to have them talk to each other. Don't have an IIS server? There is an Apache ASP plugin, Mono http://www.mono-project.com/Main_Page that allows ASP to run on Apache web servers.
Otherwise try here.
http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.> |
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
Posted: Sat Mar 05, 2011 9:26 am Post subject: |
|
|
You should avoid doing single updates per-event since you will stress the database a lot if the application lands up being used in large scale audiences. You should alter the database as little as possible with the fewest amount of calls for better performance.
@OP: What kind of application are you looking to write? Or are you planning on designing a website with this?
Edited to fix spelling mistake dur.. I shouldn't post until I've had coffee..
_________________
- Retired.
Last edited by atom0s on Sat Mar 05, 2011 6:32 pm; edited 1 time in total |
|
Back to top |
|
 |
asianking Expert Cheater
Reputation: 0
Joined: 25 Jun 2008 Posts: 109
|
Posted: Sat Mar 05, 2011 9:56 am Post subject: |
|
|
not actually a website; just a database record of installing programs to pc for office users. This record tells me who got the pc with the service tag.
_________________
|
|
Back to top |
|
 |
AhMunRa Grandmaster Cheater Supreme
Reputation: 27
Joined: 06 Aug 2010 Posts: 1117
|
Posted: Sat Mar 05, 2011 10:06 am Post subject: |
|
|
We use a similar method in Access though we pretty much just enter the serial number of the machine, the branch it was sent to, the user, the ip assigned (for remoting lookup purposes), and the date it was issued. All the software setup we enter onto a separate paper sheet, and throw it away once the data is entered into the db.
Currently, I'm hacking together a barcode scanner so I can just scan the barcodes and track our inventory.
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.> |
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
Posted: Sat Mar 05, 2011 6:35 pm Post subject: |
|
|
asianking wrote: | not actually a website; just a database record of installing programs to pc for office users. This record tells me who got the pc with the service tag. |
Is this going to be a program then? If so you can just create a web service to handle the database queries and connect to it via the application. Service binding in C# (and dare say it VB.NET) is extremely easy.
As AhMunRa suggested as well, if you plan to do a site with it, ASP.NET would be easy to work with to do a site for a front end like that too. MVC3 is released now which makes things like this fairly easy to whip together overnight.
Of course you can do all the same in other languages and so on, so which ever you are more comfortable with is up to you.
_________________
- Retired. |
|
Back to top |
|
 |
asianking Expert Cheater
Reputation: 0
Joined: 25 Jun 2008 Posts: 109
|
Posted: Mon Mar 07, 2011 5:15 pm Post subject: |
|
|
you mind given me a simple to start off. BTW, I have no experiences in C# or C++. I'm only familiar 25% with Visual Basic.
_________________
|
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
|
Back to top |
|
 |
asianking Expert Cheater
Reputation: 0
Joined: 25 Jun 2008 Posts: 109
|
Posted: Tue Mar 08, 2011 5:36 pm Post subject: |
|
|
i would careless about the service and client. What i most concern about is how to design the code to restore and save the data I posted as picture.
_________________
|
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
Posted: Tue Mar 08, 2011 5:45 pm Post subject: |
|
|
asianking wrote: | i would careless about the service and client. What i most concern about is how to design the code to restore and save the data I posted as picture. |
That all comes down to how you go about making the overall project. Like asked before, are you making a program or a website to handle this? You dodged that question before, but we can't help you 'code' anything if you have no specific idea in mind with how to implement this.
If you want to just directly access the database, which I don't recommend doing, you need to pick which type of database you want to use.
If you are designing an application:
If you are using MSSQL, you can use the provided namespace in the .NET framework to access the database:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.aspx
If you are using MySQL, you will need to use a provider made by MySQL which you can download at:
http://dev.mysql.com/downloads/connector/net/5.0.html
The MySQL provider is designed to mimic the MSSQL one, so it should be easy for you to understand them both if you need to use both for the project.
_________________
- Retired. |
|
Back to top |
|
 |
asianking Expert Cheater
Reputation: 0
Joined: 25 Jun 2008 Posts: 109
|
Posted: Tue Mar 08, 2011 6:58 pm Post subject: |
|
|
program. Not a web! I think i answer that already.
I'm assuming using visual basic alone making the database isn't possible. But I could have swear I saw someone did it before. Just that It save the info into text and when search by the user name; it would search that file and display that info in a graphical interface as the photo I draw.
_________________
|
|
Back to top |
|
 |
AhMunRa Grandmaster Cheater Supreme
Reputation: 27
Joined: 06 Aug 2010 Posts: 1117
|
Posted: Tue Mar 08, 2011 7:45 pm Post subject: |
|
|
You could make it as a standalone application in C# very easily too.
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.> |
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
Posted: Tue Mar 08, 2011 9:15 pm Post subject: |
|
|
You can do the same things in VB as C#, just port the code over. C# is just the more used language of the two as VB is fairly hated by most developers. (Not saying it's dead.)
_________________
- Retired.
Last edited by atom0s on Tue Mar 08, 2011 9:58 pm; edited 1 time in total |
|
Back to top |
|
 |
AhMunRa Grandmaster Cheater Supreme
Reputation: 27
Joined: 06 Aug 2010 Posts: 1117
|
Posted: Tue Mar 08, 2011 9:43 pm Post subject: |
|
|
By no means is it dead, I still use it at work for tons of things. Like grabbing lists of installed software from remote computers, getting the currently logged in user on a computer. Those are just easier for me in VB than anything else.
_________________
<Wiccaan> Bah that was supposed to say 'not saying its dead' lol. Fixing >.> |
|
Back to top |
|
 |
atom0s Moderator
Reputation: 205
Joined: 25 Jan 2006 Posts: 8587 Location: 127.0.0.1
|
Posted: Tue Mar 08, 2011 9:58 pm Post subject: |
|
|
AhMunRa wrote: | By no means is it dead, I still use it at work for tons of things. Like grabbing lists of installed software from remote computers, getting the currently logged in user on a computer. Those are just easier for me in VB than anything else. |
Bah that was supposed to say 'not saying its dead' lol. Fixing >.>
_________________
- Retired. |
|
Back to top |
|
 |
|