Link Database To The Application?
May 3, 2011Please how do I link my database to the application?
View 3 RepliesPlease how do I link my database to the application?
View 3 RepliesSo i'm creating a simple application as an example that is to link to a Access 2007 database.
On my main form i have four listboxes that are correctly attached to the table, I have one for First Name, Last Name, Phone, and School. I added 3 records to the database in Access to see if I could display the records in the listboxes on the form. I found that it was very easy by setting the properties and I have no problem there. I also have a command button that loads a new form for the purpose of adding a record to the database.
Here is my main form (frmMain.vb)...
CODE:
And Here is the code for the form...
CODE:
What i'm looking for is when the user presses the Add button on the frmAddNew form then it needs to close and the new record is listed in the textboxes and saved to the database. Id also like to know all kinds of things i might be able to do with textboxes and databases because i'm trying to learn for a larger project where i'll need to keep track of hundreds of records.
I understand that this is a simple procedure, but i've been spending all night scouring tutorials and getting lost in the msdn library online, so maybe some human input will be better.
I have a project that I would like to add a URL link and an email link to in the Help/About dialog. How can I do this? Is it possible to add HTML code to a VB project? This is not a Web application.
View 6 RepliesI 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 RepliesPrivate 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 be able to activate my application through my website. Like AIM, they have a protocol "aim?.." what ever, I was wondering how I might go about that? My application is standalone, I wonder if this would reduce the chances of this being possible.
View 2 RepliesI have a working Visual Basic application. I wish to have a html page that displays how to use it. How do I link it into a web browser control? This will be published and can't be just typing in the directory name as it may not exist on the client computer. How do I get it to look for the file in my solution explorer? I am using WPF in visual basic 2008 EXPRESS.
View 3 Repliesim currently improving my mp3 player (some info can be found here http:www.dreaminco...h...7&t=113445) application and would llike some help in setting up a way to connect to the application from a web link (such as the way itunes does it)i click a link in a website for opening a web stream in cisco(the application name)it opens the application then tells the media player(np_player) to connect to the stream
View 1 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 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 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 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 have novice skills in programming in vb.net,I just finish my project and applications for Data logic memoir wherein the data has been save to text file or SQL compact server database in the Handheld Device and use Active Sync Connection to pass Data into H/PC to Desktop P.C and Vice Versa.I just shift now to C#.net and start learning it and i just successfully transpose my Smart Device Project from VB to C#.
But now i want to Start Projects linking The device to server using Web services
I have browser control in a winform application that navigates to a secure intranet location. In the web application that sits in the browser are several links that bring up other windows outside of the browser... like dialog type browser windows that may contain information like user information... etc.
When I run the application in a regular browser, it runs the new window perfectly but when I click on the same button link in the web application, it brings up a windows with no data saying that I don't have access to the server.
I need the 411 on the best way to link a calendar application to Outlook to setup an appointment program in VB 2008???
View 1 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 RepliesI want to ask how to i do this :
1. Make my application to go to a webpage .
2. Open a certain link .
3. Find & Select an element(mostly element ID or div ID) on a web page like buttons etc.
4. Then extract data from a webpage . Like there's a word for example "Yellow" word in the web page . I need it to find it and copy it then paste into a textbox in my application.
Extra details : I am using Visual Basic 2008.
how 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 Replies