I am having a problem storing the contents of a field to a STRING variable. It works when the field actually has data but when it's empty, i can't do anything with it. I would like to test to see if it's empty but I run into problems there as well.
VB Version is 2008 Express
DB is Acess 2003
OS is Vista 64-bit
[code].....
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I am making a application that has the ability to edit values on a access database table. As a simple example, My table looks something like this:
Order Number Completed
2000 No
2001 No
2002 No
The application needs to edit the Completed columns. I have 1 text box, and 1 button in my form. You enter the Oder Number in the textbox and press the button. The VB application then needs to change the Completed to Yes in the database. Example, I type in 2002 in the textbox and press a button. The application changes Completed to Yes for this order number in the access database and saves/updates the database.
I am not sure how I would go about this I have a decision matrix that retains values which are boolean.The application receives a spec and rev from the database when the app is called.The questions asked as like " is it a car?" Yes/No etc.After the battery of questions I need to write the responses to an access database
Here is my db persistance class
Imports System.Data.OleDb
Public Class DBPersistance
[code].....
I have just started using databases, but I am totally stuck. I made a database and table using MS Access. The table has three columns. ID, Code, and Letter. Basically, the Code column stores a number for each letter (eg. 1 = A, 2 = B, 3 = C, etc.)
Table:
|ID|Code|Letter|
| 2| 1| A|
| 3| 2| B|
| 4| 3| C|
etc.
This table is just for reference for my program, and I don't need to change any values. But I need a step by step guide to link this table to VB 2010 and convert the values of the table to an array. For example: convert the table into the array "example" which means that example(1) = A, example(2) = B, example(3) = C and so on.
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 RepliesI currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I am using a string builder to set up an html table row by row so that it can be emailed. I currently gather my information from the database using a data reader and while dataReader.read, I use stringbuilder.Append to add each cell value to the table.The issue is that after about 200 rows, the html breaks and displays a cell value above the table in the email. I have tried changing the cell padding, but this was not successful.
View 2 RepliesI have a two different tables, Table 1 and table 2.
Table 1
-----------
Resource
Start Date
End date
[Code]....
Here I have to match the total hours of each table according to the resource,
then have to find the mismatched data and find difference with that values of mismatched data.
[code]If I wanted to get Part Name for multiple PartIDs from OrderDetails, how would I go about doing this? Would I use two DataTables? I'm confused as I cannot see an efficient way to do this. The only thing that I can think of is to create a DataTable with SQL:[code]and then maybe use a For loop to take each PartID, create another DataTable to find the PartName for that and then give this to a variable. There could be up to 10 PartIDs to search through and I don't want to have variables such as PartID1 PartID2 etc. [code]
View 2 RepliesI'm trying to connect to an Access table who's name includes spaces ('look Material Type').How do I identify this table in an OleDB string
View 2 RepliesI get a Syntax Error with the following code"ALTER TABLE receipts RENAME COLUMN payees TO payee"what I am doing wrong
View 18 RepliesI want to populate my table in datagridview from my access database table
I'm not just trying to bind the table in access to my datagridview...I want to put the data's in my access database to my table in datagridview
so far this is my code.....
Sub filldatagridview()
Dim conn As OleDb.OleDbConnection = New OleDbConnection(strConnect)
conn.Open()
[Code].....
I need to Update Access Database Table with Data from a Different Table. Not all the rows of original Table to be Updated will be affected. How do you loop through the 2 Tables to do the required Update.
The Table to be updated is called "RecordList" and Table with new Data is called "RecListReport".Every attempt I've made won't work. I tried to Use 2 Datagridviews but couldn't get it to work right.
NewTestConn()
Dim Testconn2 As New OleDbConnection(NewTestConn1)
Dim da As New OleDbDataAdapter
[Code]....
I'm trying to insert data from an Access unbounds form to an Access Table using the follwoing code:
View 2 RepliesI have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset. However, there should be something simpler and faster than that, shouldn't it? Any idea?
View 6 RepliesFirst one : i want add values to table and this is the code
[Code]...
i want add values to table and this is the code
Dim AdCounter As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ElectricityBillsViewer.mdf;Integrated Security=True;User Instance=True")
Dim AddCounter As SqlCommand = New SqlCommand(" INSERT INTO CounterInformations
[code].....
but it's not working it shows me this error Incorrect syntax near ')'.I'v made a log in program aslo it's show me an error which is Incorrect syntax near ','. and this is the code i'm using
Protected Sub Command1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim SignINStr As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ElectricityBillsViewer.mdf;Integrated Security=True;User Instance=True"
[code].....
I have been doing some listings from database, from the table "Clients", however, when it arrives to the field "Status", like it was expected, it displays to me numbers (1, 2, 3 or 4) these numbers have a relationship with another table, called "Status", which have: Single, Married, Divorced and Widower (according with those numbers).
So, I'm using a DataSet to list all the field, how can I retrieve the text in the table "Status" according with the IDClient instead of retrieving numbers?
I have a table called Table1 which already has a few other columns and 4 rows. I want to add three new columns to it. When the columns are added I want all the cells in the column to equal the variable I supply in the Add method. When I add the column named "BatchID" it works beautifully, but when I add "UserID" it gives an error "Cannot find column [iqz9]". Why? This is how Table1 should look like:
[code]...
How do i use Variables as the values to insert into the SQL table. I tryed:
Dim cnnConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=" & Application.StartupPath & "DatabaseRecords.mdf;Integrated Security=True;User Instance=True")
Dim ImportValuetoSQL As String = 1
Dim cmd As New SqlCommand
[code]....
I need comparing value from the same table for my final project.
Example :
Table 1 :
SubjectCodeClasses
Sub Aclass 1
Sub Aclass 2
Sub Aclass 3
Sub Bclass 2
Sub Bclass 3
Sub Bclass 4
Sub Bclass 5
Sub Cclass 6
Sub Cclass 7
Sub Cclass 8
...
My task is, I need to compare the classes in the subject. Sub A with class 1, class 2, class 3 have to compare with Sub B and Sub C. if classes from Sub A exist in Sub B then the output is 0, if not the output is 1. then Sub A again will compare with Sub C and the rest. After Sub A compare its value with other subject. Sub B will start comparing with all the subject and so on.
Below is the concept.
Sub ASub BSub C
Sub A001
Sub B000
Sub C100
I really don't know to do the loop..
I'm trying to Collect Bids and Distribute the average from a Column I'm getting an InvalidCast Exception: Specified cast is not valid. on the TotalSum +=
Dim sql As String = "SELECT " & Column & " FROM " & Table & " ;"
Dim dt As DataTable = SQLiteDatabase.GetDataTable(sql)
Column = Column.Replace("[", "")
Column = Column.Replace("]", "")
For Each row As DataRow In dt.Rows
[Code]...
value 33 in the textbox and select 0.3 in combo box it should take 33,33.1,33.2,33.3 values of outside temperature and corresponding power values to display the graph.
what i have tried till now was
con = New SqlConnection(connec string")
cmd = New SqlCommand("select TOP 50 PERCENT * from Vijay ", con)
[code].....
i want to restrict -ve values entering into access database table.im using vb.net as front end...
View 5 RepliesI want to select top 4 values in sql table using vb.net.. how do i select it?
View 10 Repliesi am trying to create a login access for my application. Well, i have 2 account type, that is manager and receptionist. And both account type have their own forms. which mean if i log in as manager, then i will open to the manager forms, and if i log in as receptionist then i will be open to receptionist forms. Can it possible be done?
View 5 Repliessuppose we have three tables in the Database:
[Code]....
I am working on TreeView Control. I want to create Nodes in the Treeview. For this,I have a DataGridView1 table which is having the Data.In this table i want to use First Column Data.
In the first column data the values like 3101,3102,3103....3201,3202...3301,3302,..3401,3402..So i want to create Treeview Nodes like 31 is the Parent Node and under Parent node i want to display 3101,3102,3103..are Chiled Nodes.
Finally my o/p is:
Category
31
3101
3102
[code]....