Link The LoginForm To The Database?
Jul 18, 2009i'm using visual basic 2005 and sqlexpress2005. In my Project i use the 3 layer methode . how can i link the LoginForm to the database.
View 1 Repliesi'm using visual basic 2005 and sqlexpress2005. In my Project i use the 3 layer methode . how can i link the LoginForm to the database.
View 1 RepliesI have login form as start up form and i call Form1 after successful validation and in Form1, i have close button on click of Close i would like to reset username and password fields on loginform to null. If i add code in form1 below i get exception Dim fmLogin As New LogInForm
An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll
Make sure you do not have an infinite loop or infinite recursion
I get above on LoginForm below statement Dim fmMain As New Form1
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsKashifDesktopDesktop itemsvalid.mdb;")
View 2 RepliesHow do i set username and password, and how do i make a function that makes it aviable to change the password and the username from the program??
View 8 RepliesCurrently, I have a LoginForm that authenticates a user and it works fine. I have a MainForm, which is displayed if a valid username and password is entered. I have done this by using the following code in my LoginForm:Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[Code]...
Now this does exactly what I want except I fear it's a work around and it's not the best approach. Also, note that I am using Me.Hide() to hide the LoginForm, is there a way to show the MainForm and then close the LoginForm instead of hiding it? Doesn't Me.Hide() call creates an overhead?
I had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
View 4 RepliesPicked up a legacy VB.NET project originally written for version 1.1 of the .NET framework. I'm running Vista with .NET 3.5. I have cleared out all the original error and the project will build; it just wont run.
As far as I can tell, it is trying to run 'LoginForm' but putting breakpoints in doesn't work because the error is thrown before the breakpoints are reached, regardless of where in the file they are placed.
[code]...
I have 2 forms, main Form1 and a loginform. When I start the application, first "Form1" is loaded and then with a button click, user can load "loginform" if required to enable/disable some features/controls on Form1.The sequence is like this:
1) Load main form Form1
2) click a button on Form1
3) Load the loginform.
4) enter user/pwd and click OK button
5) enable/disable "GroupBox" control on Form1 if login sucessful.
For this,I made a click event for OK button in loginform, so once user clicks the OK button, I want to call one function which is defined in Form1 as a Public, which enables/disables the "GroupBox" control on Form1. The code structure is like this:in main Form1, i created a function like this:
Class Form1()
Public Function DoThis() ' Function to enable/disable GroupBox control
....some task...
[code]....
I am not able to call the DoThis() function in loginform. Please suggest me with a piece of code how to do this?? remember that Form1 is my main form which is loading first.
I make a parent form (IsMidContainer=true) name Form1.vb. When form1.vb shows then Splash.vb shown its fine working. But now i want to show the Loginform when Splash form colse. I close the splash form in the timer tick event of progress bar. I start the timer from parent as
[Code]...
Private Sub Accounting_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conStr1 As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=C:\Users\angel\Desktop\access\University of MAkati.mdb;"
Dim SqlStr1 As String = "SELECT * FROM accounting"
[Code]...
my i know how to link vb 2008 with access? db1.mdb?and how to link it to sql?
View 1 Replieshow do i link my data from VB into Microsoft Access Db,what is the code should i write to let me link it to Db?how shud i retrieve it back to my VB by typing the some keyword?
View 3 Repliesi want to start my coding immediately about linking the database in vb...but i dnt knew how...hw i can lnk my database...
View 11 RepliesI need to link my VB10 database to a form of some sort and then be able to print the data based on the persons name and data range.
View 5 RepliesPlease how do I link my database to the application?
View 3 Repliesi have a database that I created, and I also have a form I created, example database has Flower type, my form has a section for flower type i want to link it so that I use the form to add or change or edit my database using the form.
View 3 RepliesHow to link my app to an Access database - there seems to be a number of approaches. I can add in my database via the Data Sources tab. Fine if I want to bind controls and view/edit data. But is this the best approach for queries that return an answer that is a different shape to the original table? Alternatively I can connect to the database directly (connection string, etc) and run sql queries. What are advantages/disadvantages of each approach? In terms of flexibility, is the second approach best? Also, does the second approach require the database to be added via the Data Sources tab?
View 4 RepliesWe are trying to implement a calendar in an asp.net page and link it a database. The calendar should highlights dates based on data in the database tables similar to airline ticket booking calendar.
View 2 RepliesI would like to know how I can link up my listbox to the access database.For example: I have a textbox where I enter a code and a button that says enter and the code has an item that corresponds to it and that item must appear in the listbox as well as any other items that I need to put in the listbox.
View 2 Repliesmake a calendar that link to a database in vb project. and when we select the specific date, we can display data that we have in the database.
View 5 RepliesI'm trying to link Access database with GridView control.Here's the question: One successful procedure to link database query.
[code]...
However, I got error of "The ConnectionString property has not been initialized." on da.Fill(dt) when running the second time. First time was successful.OK I finally got mistake corrected. I gotta Dim cn As New OleDbConnection("Provider = Microsoft.JET.OLEDB.4.0;" & "Data Source = C:Class.mdb") again to use query instead of once for all queries.
have a simple access database
CUSTOMER TABLE>
customer id
first name
last name
address
appointment
i want to make a simple search form in vb 2008 to search for the customer ID and have the relevant field fill up but i want to make it so what ever ID number i type in it wil give the relevant details so far i am only find how to make it load
an jus keep clicking next to go to the nex record
so i need to link the database but i want to use the bind source way, i dont like using the oeldbadaptionand all it needs to do is perform a search for records, insert new record and save the record but
View 4 RepliesFirst of all, no i am not trying to hack a database , i am trying to link to a database, created in MS Access, and have the user log into it, but i still get an error sayingQuotean unhandled expression of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll here is the code i'm using to input the password and username from a text box
[Code]...
I have a column in my database that stores images that are links, when i populate them in a gridview on my asp.net page I want it to display the image as a link but when i did it i just get the text below.url...My goal is to have a list of the images and when a user clicks the image they will go to another page.
View 1 Repliesis it possible to create a form in vb, functions able to create, update or delete records?
View 2 Replieshow can i create report and link it with MS access to display database on this report..
View 1 RepliesI am trying my hands on VB.net and is trying out a small application which includes a survey form. The form contains radio buttons and when the respondent clicks on a radiobutton, digit '1' should be placed into the relevant field of the database.I have established a dataset and tried doing it but not sure how to do it because the book (How to program Visual Basic.Net by Dietel) does not teach us that
View 1 RepliesIs it possible to link a database .mdf file to a Label or to a TextBox.text or to any form control
View 1 RepliesI am using a textbox's AutoCompleteSource I would like to link a column of a Access database. Is there a reference to it.
View 20 Replies