Create A Program That Connects To A Database And Determines?
May 22, 2009
I need to create a program that connects to a database and determines if what the user entered is in the database. Trying to do this in somewhat the same way that a translator might workchecking to find the word, and if found replace it with what is in the row beside it in the database)
Anyone have any idea on how i should go about doing this?
I know its gonna involve looping but as to how i am completely lost
i am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
I use Visual Basic.net to create a program that connects to several websites, logins, then post some data. I can't use the httpwebrequest, some java is required on those sites, so i use the webbrowser control.Now I created a form, some fields for input data and a submit button. The coding part is like this:
Code: sub website1(vars) 'login here 'post some data
[code].....
The problem is that I can't control what happens after submit button is clicked. I need to pause or stop the process at any time. If I exit the program while processing, I can see that even if the window disappear, the program is still running!I tried to use a thread for this, but the subs only get called if I use begininvoke, or invoke on a starter thread.
I am trying to make a very simple program that connects to a MySQL database using VB.NET. My program only has one form and one label. I setup my MySQL database to have a table and one field (a VARCHAR)called "Tab1". I manually inserted the value "CLOSED" into the Tab1 field using PHPMyAdmin. I want my program to change the value of the field to OPEN/CLOSED and I also want the label text on my form to change too when it's clicked.
I am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
I was trying to make a program for a teacher that automatically determines random students that he or she can call on.I'm trying to make a program that will allow the user to add student names to a listbox. Then, when a button is pressed the program will output a random name from the list. I keep getting a lot of errors and can't seem to figure out why. Finally, I need an exit button that should close the program. I need to assign access keys, have a proper tab order, and assign default and cancel buttons for the form. Also, if you know how to implement any extra 'bells and whistles' into the program,I've tried making this program but it comes up with either a lot of errors, or it just doesn't want to debug. Was wondering if I could either get some help with the coding or the "how-to" on doing this.
I have an app that connects to a sql database using the standard connection string.Now i want to do some work on this at home, where i have a vpn connection to work setup.It's quicker to work locally than it is to rdp into work and work from my desktop there.What do i need to append to the connection string to get it to connect to the server at work? i've tried appending the domain in front of the server name but that didn't work. is there something else i should do?
Basically Im going to sell software where once the user buys they register on a page, then their credentials gets added to a database, then once they open my program they login and my program checks if there in the database or not so they can advance.
I have a website with MySQL databases. I'm wanting it to connect and: display a table's data, login using a table with logins, and submit a form to go to be put in the table.
I have a windows app that has a bindingNavigator connected to BindingSource that connects to an Access database. I am manually adding a record to the underlying database using an OLEDBConnection/command (cloning the current record). The insert into the database works fine, what I am not sure on how to do is force the bindingNavigatgor to refresh and read the new record and refelect it in the record count/next/previous buttons.Jack
I'm trying to get a VB2008 multi thread application working that connects to a local server program using sockets. Server requests for this particular system can be more quickly handled by a number of connections, so I've written some code to run any number of data request threads that I choose. The problem that I'm having is that the data returned from the server is getting mixed up and is often returned to a different thread/socket than the one that requested it. Other than that, it seems to work okay. If I use just one thread, then the system works as it should. Pls. see incuded code, which is heavily edited to remove all the other fruit salad. Is there any way to set up the sockets so that data returned to the socket/thread that requested it?
Module StaticDeclarations Public WithEvents g_SD As New SocketDataClass(New MainThread.MTCallback(AddressOf MainThread.MTResultCallbackSub)) Public WithEvents g_MT As New MainThread(New SocketDataClass.SDCallback(AddressOf SocketDataClass.SDThreadResultCallbackSub))
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Suddenly whenever I build my applications, although I get a "build succeeded" result - the executables are either not updated or updated in the "wrong" place.So for example if after succesfully building I press <F8> to step through the code I get a message saying the "source is different from when the module was built"I have no idea how to begin tracking this down - how .net determines the placement of files and so forth.
I'm looking to create a program that needs to use a database I have (MySQL is the format it is in right now). The program doesn't need to change/update this database, only read from it. How would I go about making the data available to the program, without the end user having to install an SQL server?
I already Installed the components came with the VS2008 Installer (Sql etc)
The idea of the program:
The program will create a personal information of every employee including the userid and password that will be use to log in (user validation) .The application will monitor the login / logout and save the task of every employee.he application will save/store the daily activity task done by the employee (login/logout time,notes, and other task assign). the information will be saved in a database which can be access by the application in every PC within the network (LAN).The application will be installed in different PC within a network(LAN). The number of PC is not yet confirmed (5-10 PCs)
The application will be used concurrently within the network.The database will be updated after the employee save his/her task.
I plan to have ONE application only, to make it simple no server type installation and client type installation needed. Just one installation type only, the functionality/privilege will depend on the login information validation.
There will be 3 account types, Manager Account (Administrator),Regular Account (Normal Employee) and Guest account.
1. How to create an application which the database will be on the other PC within the network (LAN) ?
2. How to do it during run time/design time ( the database will be on the other pc)?
3. Can I have a guide or walk through on how to do this project?
I am trying to create a username database for my program where people create a username when they first open the program and it saves it and uploads their username to an FTP text file.The problem I am having is that I want it to do this and then display ALL users that have created a username on my program and used it in a list on a textbox. I was going to have it do this by having it add all usernames to a text file on my FTP and then have it download the text file of all the users created from the FTP and load it into the textbox on the Form that displays them all.
I am creating a rather simple program to do nothing more to show a row form a database when the form loads, the program consists of 2 forms, form one has nothing more than a label and a button to load form 2, form 2 has a listbox where the database row is listed and a button to close form 2 and reshow form 1. The code i have so far is [code]...
How to create a database using sql in vb 2008. Creating a database as in make it a valid one. I'm actually trying to develop a program. I've got everything in mind it's just that the database that i'm lacking and i am wondering if there's any idea to create it inside vb.net.
p.s. I know how to link. I just need the information to create the database from the scratch using SQL.
I'm having some issues with the suppression of the typical javascript and other scripting errors that show in the webbrowser.I have three webbrowsers. The third webbrowser goes out and determines some action based upon location. The one thing I'm having trouble with is this example. It states that it should work but the errors keep on coming.I attached some of the code below. Am I doing something wrong?
I trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
i have sql 2005 and i want to develop a small program that can access the database and amend a few rows of data. in sql database, i have 1 table and it consist of 3 columns = datetime, type & price. below is example:
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.