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:
[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 have tried to create a bar to search the form
View 1 RepliesI am trying to create an application that adds the contents of a till to a database. (Does this on two forms into two different sets of db columns) and can pull that back up at a later stage. At the moment, I'm stuck at the first section?
BODda.Update(BODds, "Data")
Is where I get an SQL error stating:Syntax error in INSERT INTO statement.I have not been able to find a way to insert via SQL?
I had a look through this forum and other forums but couldn't find what I was looking for. I am new to visual basic and have spent all day trying to find the solution to the following issue.I am creating objects from a class that store information about the user of the program. Each time a user signs up the program, I need the code to create a new instance of the class, creating an object and storing information about that user. The contents of this object will then be saved into a text file.
[Code]...
1)How can I make my program get the contents of a .txt file on my website to tell the program to run or not?Here is and example of what I want:Say the file says "Running", the program would run without problems.If the file was to say "Unavailable", a pop up would appear saying "The program is currently unavailable, try again later." Then once the person clicked OK, the program would close.
2)How can I make the program get contents from a .txt file to get the latest version of the program, then if there is a newer version, there would be a pop up saying there is a newer version and they need to update. Then when they clicked OK, the program would close and it would open their default web browser or Internet Explorer to the update page.
I have searched google and youtube for a tut on this but cant seem to find any :/I have a script that adds contents of textbox1 ans textbox2 to a online mysql database like username and and password.All this works perfect What i now need is to display the contents of the given database in a listbox or something.How would i go about this or is there any good tuts on this, all i seem to find is tuts using ms database not mysql
View 6 RepliesI'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?
View 9 Replies"Employee Monitoring Program"
Source: Visual Studio 2008 Pro
Language: Visual Basic
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?
how i can write a program to create a shortcut in the startup folder of a different program. So i have one program on my computer that should run at startup, i just need another program to create a shortcut to it, and then copy this shortcut into the startup folder.
View 20 RepliesI 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.
[Code]...
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]...
View 4 RepliesI 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 have this Quiz software that lets you create online multiple choice quizzes which are great for studying (I am in grad school and I'm trying to use everything I can to learn). So the Quiz software is great but it only lets you input questions by hand, one by one. I took a look at the .xml file that the quiz program spits out and came up with the idea to try and make a converter so that I can import many questions at once. I was hoping to try and solve this limitation by doing the following:
Take a .doc that say a tutor gives us with a bunch of practice questions, and then take that into Crimson Editor, and then format it so the question is on line 1, the multiple choice answers are on lines 3,4,5, and 6, (for the next question, the question would be on line 11, and the answers on lines 13, 14, 15, and 16, and so on) and then take that saved .txt file into my program, hit the generate button, and it will spit out the .xml file, and then import that into the quiz software to generate the online quiz.
Here is an attached screenshot of my program layout so far:
I figured out how to open a text file by watching simple youtube tutorials, but I don't know how to have it generate the stuff and have it show up in the bottom text box. I know how to do the coding to convert the txt to proper xml code but I don't know how to be able to save the contents of the bottom text window to an xml file.
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
View 1 RepliesI have a slight problem with something i am working on. I found this module here:
View 2 RepliesIm 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 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"?
View 9 RepliesLets say I have a program that has a textbox and a button. I want the button to create another program that will show a messagebox, inside the messagebox will be the textbox from the 1st program. How would I do this?
View 7 Replieshow to create a program that can access information held in an excel database and show it in a simple form.
View 2 RepliesI want to create a datatable using he contents of a DataGridView.
View 9 RepliesI am trying to create an exe file through my program. Please do not get this mistaken for trying to create an exe file for my program. I know how to create an exe for my program. However, when I run my program I want the user to be able to select some files and then those files will get added to a list. Once they are done selecting files I want them to be able to create and exe file that will copy those files to whatever computer they run it on.
View 1 RepliesWe're working in the book "Advanced Programming Using Visual Basic 2008.(Pg.34, Praying that someone has the book) Anyway, I suppose to create an payroll program, I have the layout done. What I having trouble with is the coding, I mean, how do I start? I know how to code the buttons and menus. But, I don't understand how to input the codes for the employees, or allow only #'s to be placed in the text box.The payroll, suppose to be able to calculate the employees Hours, Rate, and Pay. As you can tell I'm a complete noob with VB, just started using the program.
View 1 Replieswe are suposed to create a program that we like with certain peramiters, I have done as much however I have an error and I can not find a solution anywhere. We are, before you ask, able to seek help on this matter. Here is what I have:
[code]...
I'd like my program to create a new picturebox from time to time. I'm not sure if this is possible though.I thought of sometime like this:
Me.PictureBox4 = New System.Windows.Forms.PictureBox
or also tried to copy the code from the designer, but it didn't work.
I am trying to create a pairing program.to get a format like in the Image.Here is some of my code... I am goining wrong somewhere, and my loop is infinite or something...What am i doing wrong?
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim r1, r2 As Integer
Dim MyValue, MyValue2 As String
[Code]...
when a user logs into their account on the laptop , Remote Desktop Connection automatically logs them into their account on the main computer. The problem is when it comes to logout, i need to create a vb program that will run in the background , so when the user disconnects from RDC ( which also closes RDC) it automatically logsoff the laptop. hope this makes sense.
View 1 RepliesI am in process of developing a student database for my husbands institute. I am completely done with the design of screens. Now I want to create database using sql plus ( as i am trained in it). I would like to know the process of connecting the database with the application.I would also like to know the process for the following :
1. When i create a student registration form, it should get updated in the database.
2. When i try to delete a student's record it should get deleted.
3. When filling the registration form , if any mistakes, i shall refresh and fill again.( i have designed buttons already).
4.On completion of the present academic year, the details i mean the class of the student shall be updated automatically.
The above are few requirements i need for my application.
I'm new in development in vb.net IDE, and I need your advises on how to create multi form in one screen like a project properties screen in VB2008 IDE, thus when you you go to Menu Project -> Project Properties... you can see that screen is divided into two panes the left one for options to choose and the right one for configuration and preferences.
I need to know how to achive this and how to create similar to that thus if you choose any button from left the form content changes at right (ok is this single form and all controls were set to invisible /visible or is it muliform programming.
I have another question : how can I change the Left pane with Treeview control and choose my option from there.
Give Me Some Examples
View 2 Replies