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 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]....
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?
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 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 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 RepliesI'm looking for How to build object for use in my program. Example: I want to button my style and add it to toolbox and I can use it in every form and every project.
View 9 Repliesmy visual basic create a .sdf file for every database but then when i try to access it it says that its an unknown database file extension. i used a tutorial which used a .mdb file which i had to download and it worked fine with it. how do i create a .mdb file
View 1 RepliesHow can i create msi installer for my designed project in vb 2008
View 8 RepliesI want to create an array of constant variables for my program. But from everything I read about arrays they are handled by a number. I want to be able to pass back a variable that will hold the name of the constant as well as the value. How would you go about do that.I want to when I type the variable to have the constant name show up as I am typing.
View 4 RepliesI'm trying to create a program which accepts a letter of the alphabet. For each letter a corresponding word beginning with that letter should be output, e.g., �a� or �A� input would give Alpha as the output, �b� or �B� would give Bravo and so on to �z� or �Z� giving Zulu.So if the user enters: "abc" for example, what should happen is a list on the right of the window appears with the words starting with those letters when the user presses calculate.I don't have any code apart form the basics below.
Public Class Form1
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
End Sub
[code]....
I want to do a task with a function controlling database with vb scripting. My form will include textbox, button and datagridview to view the database table manually without add from the microsoft access or other..how i want to make the table appear when i put a number into the textbox that refer to the number of row and column and then click the button to create the database table? Besides, how to rename it using textbox?
View 3 Replies