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 RepliesNow 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 RepliesNow 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 RepliesI'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.
I am creating a program for an existing database that stores the info into the database. So can I link an already existing database in MS Access to a GUI?
View 2 RepliesVisual Basic Project - Student Check In Form using an Access database backend This form needs to draw information from an Access database containg tables for STUDENT, INSTRUCTOR, and SECTION. These all need to have primary keys and ids. When (the user) clicks on the drop down box that displays all the sections:
{Table Tennis 1, Table Tennis 2, Table Tennis 3, Billiards 1, Billiards 2, Billiards 3}This should populate the listbox or datagrid from the STUDENT table with the Students that have the same SECTIONID as the SECTION selected in the drop down menu above.
After the Student list has been populated (the user) clicks on a student name in the listbox/datagrid and this inserts that student into the CHECKEDIN table that has a datagrid/listbox associated with it.
This is a great project to practice connecting a database to Visual Studio 2008 .net and playing with the data that has been pulled in. You could use SQL instead of Access.
when i try to run my form it says:An error occurred creating the form. See Exception.InnerException for details.The error is: Cannot create ActiveX component
View 5 RepliesI have another question (and anticipate that I will have about two more before I'm done with my class project). Here is my issue (and I'll copy and paste my code for clarification). I need to link up the control from the form on either side of the current form that I'm working on so that if I click on the buttons that I'm titling previous and next that I can click on the proper button and either go directly to the previous form or the next form. I was successful in doing this for two earlier forms on this project (with some direction from a couple of helpful people on this forum before), but for some reason, no matter what I details I use the controls do not connect to the previous and next forms.
Option Explicit On
Option Strict On
Option Infer Off
[code]....
I have two forms , and I want write a code like ( form2.show=true & form1.show.false)
View 2 RepliesI'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.
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 RepliesI 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]...
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 RepliesI 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 RepliesI 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 RepliesBelow 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 RepliesIm 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 RepliesI'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 RepliesI 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.
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]...
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!
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 RepliesIam 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 RepliesI 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]...
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 RepliesWhen 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 RepliesI 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]......
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] .....
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?
creating my login how can i connect to database using access or sql or any other data source
View 1 Replies