I need to know who to write data from several text boxes on a form to a sql database.I have created the sql database on a localhost using myphp admin, i have created the connection in a module named as dbconnect()i can try the connection and this connects fine, but unsure how to write the data from the texboxes to the database.
View 3 RepliesVB2008 with MS Access Database updated related data ?
View 9 RepliesI'm trying to retrieve data from an Access database - a simple one. (Just a single table with one column) My task is to view these records through a 'ListView'. No need to manipulate or anything. Just to retrieve data with a simple SQL statement and display via a ListView.
View 4 RepliesI am developing an application in visual basic 2008. I want to populate a drop down list onthe fly with values extracted from the database. I want both the displayed and value items to come from the same.
View 1 RepliesI am having a problem with an application that displays data in datagridview depending on a selection from a combo box.The problem occurs when I want to write the data back to the database.
I get the following error:"Update unable to find TableMapping['Product'] or DataTable 'Product'."
Is this because the table in the dataset is filled in a private sub? If so how do I make it public?
Any ideas what is wrong. Code is as follows:
[Code]...
What I want is to have the ability for the user once the values are entered into the Textboxes, the user has the ability to save the values for retrival a some later time. This is what I have so far
[Code]...
I came upon your forum while googling my problem. I respect the fact that you don't do someone else's work as I wouldn't either. But, as a beginner I have a lot of questions so hopefully no one minds.
[Code]...
I cannot figure out the declarations to write to an excel file that is already open.
I open the excel file and make it visible with this:
Private Sub Button1_Click
Dim objExcel As New Excel.Application
Dim objWB As Excel.Workbook
[Code].....
I am trying to write a code for a exponentiation calculator in VB2008?
View 2 RepliesI decided give up vb6 and begin use vb.net.And I'm going to update my old vb6 code.I used write a vb6 program to update my program.it's a simple program:I have a webside,I put a file in the webside,this file it's just a document(.txt),only include version number.my program use "inet" download this file(address like this [URL]and compare the version number,if this document number it's bigger than this program number,than told user you need update your program.like this:
dim ver as string
ver=Inet1.OpenURL(http://www.sample.com/info/ver.txt)
[code]....
But,In vb2008,I don't know how to write those code.I search the local MSDN,it said I can use:""my.network.download" to download files,but it's only can download a file and save it as a file,I want to download a file and save it as a variable(type is long),I don't know how to write those code.
what I am trying to do is i have a table with four records and I want to write it to a txt file. I am running sql server 2000.I am able to connect to my database and I am able to right data to a txt file my only problem is it always returns the 1st row of data.
Dim FILE_NAME As String = "C: emp est2.txt"
Dim conn As New SqlClient.SqlConnection
Dim da As New SqlClient.SqlDataAdapter
[code]....
What do you think what is faster:
1. writing 1000 records in a binary file on a server? or
2. passing the same 1000 records in a database on a server?
and
1. search a specific record in a binary file? or
2. search the same specific record in a database file?
I'm trying to write data from an excel spreadsheet to an Access database. When i run my program a message appears saying that the correct number of records have been saved, however when i check my access database no records have been written to the database table.
The following is a copy of my code (sorry i've just edited it to get rid of the white space that was added when i included it here for some reason.The code for writing to database:
Public Class Form1
Dim connection As OleDbConnection
Dim Command As OleDbCommand
[code]....
i've download the 101 Visual Basic and C# Code Samples from downloads/details.aspx?familyid=08E3D5F8-033D-420B-A3B1-3074505C03F3&displaylang=en i was going to learn "VB.NET - Data Access - Read and Write Images from a Database" from that 101. the program is written in 2003 the conversion of the problem to 2005 and 2008 failed.
View 3 RepliesI want to read data from excel sheets and write into tables in database visual basic 2010. I am usinq Oracle 9i for database.and my objective is that user should select excel file and if button is pressed then I want to extract data from excel sheet and store in a already created tables.
View 5 Repliestrying to write a dynamic sql query that fetches data from oracle 10g database. My Where criteria is giving me real problems but i guess it has to do with the oracle data format. The data column is a TIMESTAMP data type storing values like 25-JAN-09 07.06.01.000000000 AM. Am trying to get rows having the columns matching a specific date( ignoring the time values), my where looks like this
WHERE to_date(COMPLY_RUN_DASHBOARD_DATE,'DD-MON-RR')='" & Now.Date & "'"i get the following error :CheckError ORA-01830: date format picture ends before converting entire input string
Sample: EscreveByte = Val(AscW(Letra)) sw.WriteByte(EscreveByte)
[Code]...
I am trying to figure out how I can add data from my textboxes to the appropriate tables and columns in a Microsoft Access database that I have made
View 7 RepliesIm trying to switch from VB6 to VB2008/VB2010 and i have managed to convert all my old code to the new. The only thing i cant figure out is how to use the new database system. How can i convert this code to be used in VB2008 ?
Dim vntTemp As Variant
Dim vnDummy As Variant
On Error GoTo Form_LoadError
[Code].....
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dprovider, dsource As String
Dim ds As New DataSet
[code]....
The code above can access the database but it refuses to add,update,or delete any records..
A while back I have created an application with ms access 2003. But ms access is limited to what it can do. So I have started to redesign the application in vb2008. The application is a registration/reminder/payment system for martial arts school students. I got stuck with 2 questions.
1) I have added mdb file into vb project, but I don't seem to be able to assign mdb fields with form fields. The only way it lest me do it if I go though a wizard, and then my vbform looks like msaccess form, which I don't want it to look like that. I just want it to look like any other normal application, without the db navigation button at the bottom of the form. If someone has a tutorial that I can look/read to find how I would assign db field to form field.
2) My other concern is that I need the vbprogram to be separated from database with having to create odbc connection. The main reason, is that I always need to add/change/fix features. And that is the main issue I am having with my msaccess app, that is while I am working on it, no one can add/look at the student records. What I would like to do, is that I have a vb app, that will look for .mdb file at the certain location, if it is not there, the use would have an option to either browse for it or create a new one.Then I can do all of the modification and send the updated vb app to the person that works with it, without hindering his/her work.
I'm still passed from VB6 to VB2008 and...I found it very changed!I've learned in few days how to use the most used commands, but I've got a big problem in connecting to an Access Database.I saw that we can connect to a database using:
- wizard connection
- manual connection
I think that using the Wizard everything is more cleaned and I can reuse the code in a simple way.So I tried the Wizard Connection, but all the guide and tutorial explain the connections using DataGrid. I don't want to show DataGrid. I've learned how to import data in listboxes (also in auto-complete mode) but I cannot understand how to work on data in the way I prefer.
- I've got a combobox with a list of data
- When I "change" the selection (combobox_SelectedIndexChanged) you have to load related data (from another table) in a ListBox (in which I can add other items without inserting them in the DB)
- Send all the data loaded in this fields (there are also other data) to create a record in the DB (like "Order of Product")
i'm developing a linq to sql database application that i created with visual basic 2008. I intend to install the application on another computer system. The problem i'm having now is that, after i've developed,deployed it and installed it on another computer, i can't find the linq to sql database i created with the projectkelvin rolex on the installed application on the other computer,
View 3 Repliesi have mad e a database with the following tables...username varchar(50)password varchar(50)as you know it does the rest for you"now i have a form with..TextBox1 for username textbox2 for password
my database is called "jonno-laptopsqlexpress.username.dbo" now if i add usernames and passwords in to the correct tables how can i login via he textboxs?
I simply want to do this :
1. Creating a textbox1.text
2. Creating a button.
3. Coding the button so whatever is written in textbox1.text will be saved in a .ini file.
Quote: My.Computer.FileSystem.WriteAllText("c: ext.ini", TextBox1.Text, False)
I have developed VB2008 application and MySql as Database.I want to Open this application on any web browser without making any changes in Orginal application.
View 8 Repliesso 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 RepliesHow to Retrive Image In MC Access database Using VB2008
View 1 RepliesI want a to create a combo box that gets the selectable items from a table and when I save the form I want the selected item saved to a different table. I'm sure this is simple I'm not a database wiz and still very much a newbie.
View 4 Repliesin VB6 I used the following code to access my Access database tables:
Global gdb As Database ' Global instance of the database.
Set rs = gdb.OpenRecordset(".....various SQL statements")
I am confused about how to do the same under VB2008 Express. "Public dbs As DAO.Database" does not work.