Creating A Database On The Fly?
Apr 25, 2011
I'm trying to develop 2 companion applications. One application will be a FileSystemWatcher service application that will create/maintain a database containing file metadata (file properties) from a specific folder structure on the user's C drive. The other application is executed by the user which contains edit boxes pertaining to the metadata. As the user enters data in the edit boxes, the code will execute an SQL statement which in turn will display a list of file matching the entered criteria.
I'm thinking about using Microsoft Access as the database since all users have it but I'm willing to use another database format as long as it something intrinsic to the Windows XP 64 bit system (i.e. I don't want to install another database application in order to utilize its database format). So, do you have a suggestion on a database format? Do you have some pointers or links, on how to create database file and tables on the fly? Should I use DAO or ADO or something else? I'd prefer to work in VB.NET.
View 1 Replies
ADVERTISEMENT
Dec 5, 2011
In Beth Massi's Video How do I Create a simple Data Entry Form in Wpf? Video you use a Oms Data Base but it does not tell you how. Can someone please tell me how. Iam using Visual Studio 2010 In Vb code.
View 2 Replies
Feb 1, 2012
I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below,
[Code]...
View 5 Replies
May 4, 2011
I am creating a VB.NET application that will use a FoxPro database as it's main datasource.The problem I've got is that I can browse existing databases and pull out data with no problems at all but as soon as I try and create my own database I get an error message saying "One or more errors occurred during processing of command." (which is helpfully vague).[code]
View 1 Replies
Sep 27, 2011
I have written some software for a company I want to start, basically I want to supply automotive parts. The software I have created uses a database to hold information for users, parts, suppliers and so on.I want to write in a search bar so I can search for a part by name.The code I have written so far for this form is basically what is created when the new dataset wizard is used.[code]I have a datagridview that loads the data for my partslist table, underneath there is a textbox control for my search bar and a button to perform the search, underneath that I have placed another datagridview control to receive the results from the search.Can anyone help me write code to perform a search and place the results in the second datagrid control.
View 2 Replies
May 18, 2012
I am trying to create an empty table from scratch using Microsoft SQL Server Compact 3.5 and I am running into this problem.Please take a look at the screenshot below.[code]How come I do not have the same screenshot as the web site link below as Frank Smith showed in his example? What Do I have to do/install to have the same screenshot as in the web site below? I have Visual Studio 2008, Microsoft SQL Server 2005 and Microsoft SQL Server Compact 3.5 installed on my computer..url...
View 1 Replies
Jan 30, 2010
i want to know how to create a log in form using a database..i've watched some videos but its failed.im using visual basic 2008 and access database 2003...i have created a table for password..
View 9 Replies
Jul 17, 2009
Below is my code for creating a database and then, from there i hope to be able to create more than one tables in the same database that i just created. But for some reason, Visual studio 2005 keeps reminding me that the SqlCeException was not handled or mishandled. Error lies in the "sqlCreateTable.ExecuteNonQuery()"[code]Actually i heard from someone that you can actually create all the tables that you need such as "Login", "Order" and so on in a single windows form(in form_load) , which will load up all your table and create them for you if that window form is the first object to start running in the order.
View 3 Replies
Feb 22, 2009
Im would like to create relationships between my tables from different database. im using VB 2008 and SQL 2008 as my database. Is the relationships should be made on my database itself or tru coding in my VB? If either which how can i do that.
View 2 Replies
Jun 19, 2012
I've been having some trouble wrapping my head around how to link the 4 tables I have together. I'm creating a database to store all of our equipment in. The four tables are Equipment, Service (Stores dates that a piece of equipment has been worked on), Invoice (Stores invoice and warranty dates) and Peripheral table (Stores a unique ID for each type of peripheral we have in the database. Monitor (1), mouse (2), keyboard (3) etc)
View 4 Replies
Nov 15, 2011
I want to create a relational database in VB2010 and I am attempting to accomplish this goal by creating a structure of records to be stored in a Random Access File.For each record, I want to organize each fixed-length record so that 4-integer sets of data are stored into a a multi-dimensional array.But when I try to write the code below at the module level, I get an error.
Structure PictureDat
'len= needed for Open
of Random Access File [code].....
Since I want to read/write/save the data in this structure to a Random Access File with a fixed record length size, I need to exactly specify the size of the record...which is, of course, determined by the array's dimensions.If I could accomplish this strategy, then I could search this random access file for a match of search criteria consisting of 4-integers with any of the 4-integer sets of data in each record and thus find, edit, delete and search records...therby retrieve information from my database.
Is my program design inefficient? Is there a better way to handle perhaps hundreds of thousands of records? The IDE keeps telling me that I am using a deprecated method of file I/O when I use FileOpen(), FileGet(),FilePut() and should be using MyFile.I am entirely comfortable with my time-tested method of data storage that ensures the security of disk storage while exposing only one record at a time to the PC's volatile RAM, thereby not allowing all my data exposed to possible memory corruption on a PC left on for hours, which would be the case if I loaded the whole file as a monster- sized string or stream. Also, these older file access methods allows my code to run on PC's with modest amounts of memory.
View 9 Replies
Nov 30, 2011
I am currently creating a windows form app with a database.The database hosts links that the user can customize.When I go to publish the file, if user A changes the Link to their liking user B also see's the changes and will cause a clash if user B does not need the link that user A has put it.
I wish to be able to have a unique database for each individual and for the life of me cannot figure out how.Currently I am having the person upload to an access DB. This is not required but I am lost for ideas
[Code]...
View 4 Replies
Jan 19, 2011
I've been viewing the tutorial at [URL]...08-088541.html but I'm still having issues creating my connection to our Oracle database. Here's my code, which uses the same connection string as one of my VB6 programs (no password required for database--Oracle picks up windows name) :
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Create connection object
Dim OraDB As String = "Data Source=databaseneme;Persist Security Info=False"
Dim conn As New OracleConnection(OraDB)
conn.ConnectionString = OraDB
conn.Open()
Me.Show()
End Sub
I've been using .NET for all of 10 mins so the error may be painfully obvious!
View 18 Replies
Jun 9, 2011
I have decided I would start small and make a program that would create a "receipt" list in a listbox and a total. Now, I would like the user to be able to add their own "menu" items. I'm assuming the best way to go about this would be to have them actually add it to a database and then a function in the program will refresh the dataset with the new list. However, this is where my problem lies. How can I tell VB .net 2010 that I want to create a new button (or buttons) on the fly, in an orderly pattern on the form, based on the input from a DB?
View 10 Replies
Nov 15, 2011
Iam using firebird v 2.5 database with vb.net . how to create a new user in fb database programmatic ally in vb.net .
View 2 Replies
May 26, 2012
I have seen a few .NET apps use .db files. I am not new to Visual Basic, however I have never created a VB app that uses databases. I do know PHP pretty well, and working with databases in PHP I am familiar with.
[Code]...
View 1 Replies
Aug 2, 2009
I'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?
View 7 Replies
Jun 12, 2009
When i'm trying to create a new SQL Server Database in VB.NET 2005 through Server Explorer i'm getting following error (no matter what authentication i select):An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider:Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)i have properly selected my Server and entered a different name to the new database.
View 3 Replies
Mar 15, 2012
I have this in creating table but did not work. Having invalid table name error.
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
Public Class dump
[code]......
View 3 Replies
Jan 7, 2010
On my development PC I have SQL Server installed, and my SQL connetion works perfect. I use a trusted connection. But on other PCs, where the program should work later, there is only a SQL "Express" installed (by another application), and it seems they have an password on the SQL Server (I guess). I have no chance to get the password from the other application. My connection is not working here. I created some connection test, but it does not seem to work with the trusted connection. I need the SQL only for creating my own database and connecting to my own database. So how do I create a connection with SQL Express for creating and working with my own database?
Here my code for testing the connection so far (Fehler means Error, erfolgreich means Success) Private Sub mnu_Verbindung_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnu_Verbindung.Click
Dim bolFehler As Boolean = False
Dim sServer, sDatab As String
[Code] .....
View 7 Replies
Apr 8, 2011
I am using VS2008, language VB, and MySql.I have a simple database app joust for practice. It has one table that contains ID, Name, Surname and Age fields. The code I am using is:
[code]...
Now I would like to something like this:
[code]...
Value of type'System.Data.EnumerableRowCollection (of char())' cannot be converted to 'string'.What am I doing wrong?
View 4 Replies
Aug 16, 2010
creating my login how can i connect to database using access or sql or any other data source
View 1 Replies
Mar 25, 2011
I need to create a login page as part of an assignment. Problem is, I don't have access and I'm not sure which other programs can be used as alternatives. I am hoping that it's possible to create the login screen using only a If...Then...Else Statement. If it is possible, I'm probably going about it the wrong way, as it skips the first two conditions and goes straight to the 'Else'.
Private Sub OK_btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_btn.Click
Dim Message As String
[Code].....
View 14 Replies
Apr 16, 2009
Now I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 1 Replies
May 11, 2009
Now I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 5 Replies
Mar 24, 2012
I am trying to create error messages to display on a form. I added a label that is made visible if there is error.Currently if the database name is wrong the error message displays, however if I alter the connection string; example: If I misspell Server, the error label does not display and my application crashes when I try to click a control.How do I detect and display the error label, when there is no connection or a part of the string is misspelled or missing? Is this even possible? [code]
View 3 Replies
Nov 22, 2010
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
CreateDatabase()
End Sub
[Code]...
View 1 Replies
Feb 5, 2011
I'm really new to any form of VB programming and I am trying to create a form which will allow me to take information from an attached database holding information on:
class names (i.e. Year6 Dragons)
Students names (i.e. Sarah Jessica Parker)
I want the design to look very similar to the form used in MS Access for the query wizard, which will allow me to choose a class and then specific students.
View 1 Replies
May 31, 2010
I am here to write a small database application that will be running in desktop (offline mode).I am using MSAccess 2007 as my database file and trying to write code in vb.net.I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.I am trying to upgrade myself from vb6 to vb.net.do i need to read some more simple starter books also?
View 3 Replies
Jan 18, 2010
i am creating a booking system for my A2 project but i cant create tables or field in the database and enter information in them. I have created a ms access database in vb but after that im stuck. The database must be created in vb programatically as i get more marks for complex code.
here's my code
Imports ADOX
Module Module1
Sub Main()
[Code].....
View 3 Replies
