A year or so back I made a database management program in vb.net and now its out dated and i want to start from scratch, since I wasn't very good at vb.net at that time most of it is hacked together in one single file.Now i want some tips in making these kind of programs.I've heard of something called a data access layer. What is it and Should I use It ? Is it a Class or interface (I don't know what interfaces do yet but they should be to hard)?
I am working on a small personal database management program and am at the stage where I am trying to search the MS Access database given a user input.I need to look up lets say the "customer" ID and the update other records associated with that customer. Here is what I have so far.
I'm have a data management program. I've fixed everything in it, except when I run my Insert or update commands on a different computer I've installed it on, JIT tells me that the collection has be modified, it then gives me the option to continue or quit. I know it's been modified, the user knows it's been modified, how do I get rid of that?
Using Vb.net 2003 Asp.net 1.1 Sql Server2005 Express Vs.Net 7.1. I have Vb.Net Standard and there is no Web Set Up with this version. I have FTP things along time ago but not asp just basic stuff. I have read about xcopy,copy project, I have XP and IE that I can FTP from. I also have to put a database up from SQL Managment Studio. I need to know HOW WHAT WHEN WHERE on how to do this right. This is an interactive site that I made, very similar to a Forum like this site. Do I just upload the dll.
I don't want my source code available for everyone to see, do I have to obfucate it if I am using [url] as a host. The site can't really be down all the time, I have read that I could work on thesite while it is up but I believe I will have to have all the source files up and open.
I just wanted to know if visual basic 6.0 or Visual Basic 2010 can be programmed to create a system that uses both smart card reader and sensors (photoelectric sensors) and be recorded their information into a information management database for date and time log.
Example:
1. A personnel will have to tag their smart card to the smart card reader. It will then be checked from the database and approved if their record is available in the database.
2. He will then have the access to enter and take a particular stuff from a rack (which has the sensor) guarding on each item on the rack. If the personnel take the item. It will then be logged into the database for the 1. personnel I.D, 2. item position on the rack, 3. time and date when the item is collected.
Question:
1. What hardware are needed to incorporate all this (smart card reader and sensors to database)? a controller perhaps? terminal for all the sensors?
2. What software to create the information management database so an authorized personnel may check the event history? also software to incorporate with the sensors? will it have to be on separate software or all can be done in the package given in VB6 or VB2010 or an additional software to be used?
3. Does MSComm Control have any relevance on this subject? All i know is what it does (vaguely) and no idea how to implement it.
I have read a ton of stuff about this but not getting it, noob error I am sure
Type 'System.Management.ManagementObject' is not defined. Type 'System.Management.ManagementObjectCollection' is not defined. Type 'System.Management.ManagementClass' is not defined.
I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
I am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
i wanted to know how to deploy a simple program that is coonected to a access database.I have tried it many times but when I try to install it says that some file is mising. How can I do it so that I dont have to copy the database from one computer to another.
using visual studio 2010. I have a vb.net application that needs to be updated periodically. The software stores client lists in a database for the user, but when the user reinstalls the program after I send them an updated publish, the client list database is replaced with a fresh empty database.
Is there a way that the user can reinstall the software without losing their current database?
I don't know if I need to somehow make separate publishes. One for an initial install to set up the database, and then one for updates that leaves the client database untouched? I don't know how to go about it.
Is there any way to have the program still run efficiently when connecting to an mysql database? Would System.Windows.Forms.Application.DoEvents() work anywhere?I have it connecting every 3 seconds on a timer and during that connection the program locks for a second.
Im Trying to create a NotifyIcon Program. I want this to basically be like a service that every second looks at a database to see if anything has changed this is the module thus far
Imports System.Data.OleDb Module ModNtifi Public conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\MyserverMyDatabase.accdb ;Persist Security Info=False")
[CODE]...
The Problem i am getting is that after the start procedure has finished the program closes. i want it to start the the timer and then keep it going till the user exits the program manually.
i try to make a program that can share a database to other people using a upload/update system but when i try to download/upload it keeps saying mdf file in use how can i make the code so that it Uploads and overwites the file without that error.as it must be so it must upload to my server (build in)and download (also build in)the error gives file in use constandly how can i fix this issue?of that file in use problem. even when these no querry or other code running?
I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?
Heres the screenshot and codes
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click
I coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
I am creating a very simple Voting System, that will be use on electing new set of officer in a teacher cooperative...
So I have to create two separate program, a Server Program that will manage all the information in the election and a Client Program where voters will vote their selected candidate...
The election officers wanted that the Server Program will display the Voting Results at real time... So when the Voter finished voting, The Voting Result displayed by the Server Program will also be updated every time the Client Program Insert the data to Database....
An action listener in Server Program that will execute if new data is inserted in a Table in the Database made by the Client Program...
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003 Search in file Pokemon Dex Numbers 003 returns Bulbasaur Check Bulbasaur base stats in the base stats file etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI? -Databases would load internally? -I could search a database without having to load it into like an array or something?
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
i have a application that i designed for an assignment which uses a DB (ACCESS) However when i publish the application it fails to load even though the application completes. I have managed to find that it is the database that is not copying over, how do i solve this (the db is located when debugging and is also in the project files)
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
I am using VB Express 2008, and I'm experimenting with querying WMI. I have tried the code samples from MSDN, but they do not compile. Here is an example of code that my IDE doesn't like:
Imports System Imports System.Management Public Class Query_SelectQuery Public Overloads Shared Function _
[code]....
In this case, SelectQuery and ManagementObjectSearcher are underlined with squiggly blue, and it doesn't know what these are. What am I missing here? Please help, because I'd love to be able to write console apps that query WMI.
I am using vb 2005 and need help with trying to do the following :A Form that has a combo box , a listview and 2 command buttons( When the form loads ) i need the combo box to be enumerated with the printers that are on my server ( so will need to connect to my server which is obviously a remote machine ).Then when ever I select a printer from the combo box, it enumerates the listview with any print jobs that are in that printers que and I am able to select either one or multiple print jobs and click on the cancel print job button ( which will cancel any selected print jobs ) or click the cancel all button which will just delete any print jobs in that printers que.I know this is a lot to ask but even if I could just get an example of how to enumerate the printers into the combobox and get the listview to display the print jobs ( If any exist ) for that specific printer.That would be great.
I wrote this VB program to be able to throw a device we developed into programming mode where we use an ATMEL Flip installer to upload new firmware. I can program one device after another running the application off of Visual Studio Express 2010 or Visual Studio 2010, but when I go to publish this file and run it on another machine, it becomes unstable and crashes after each upload. On those same computers if I run the raw unpackaged program under Visual Studio Express, the system does not crash, and I can program devices repeatedly.
I've been working on a program that generates a batch file, then when you press a button, it executes that batch file. There are multiple batch files attached to each item in the list box.
[code]...
The only thing that it does when I press the button, is starts the batch file, then goes to function searchtitle, which executes the batch file again when it finds out it didn't work properly.The button text doesn't change, none of the items are being added to my first list box, and I can't do anything to the window after pressing the button. It constantly opens the batch file every 5 seconds or so.
