hathan
Last Activity: Dec 11 '07, 08:37 AM
Joined: Dec 4 '07
Location:
-
I dont understand how i would do that, i have read the link to setting an insert command to the adapter but i still dont get it. Someone please help. -
VB 2003.net Syntax error in INSERT INTO statement
Hi, i am trying to add a new row into a microsoft access database and cant understand why it wont work. Can anyone please help me understand what this means? The error message says:
************** Exception Text **************
System.Data.Ole Db.OleDbExcepti on: Syntax error in INSERT INTO statement.
at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows, DataTableMappin g tableMapping)
at System.Data.Com mon.DbDataAdapt er.Update(DataT able... -
An unhandled exception of type 'System.Data.Ol eDb.OleDbExcept ion' occurred in sy
Hi i am getting An unhandled exception of type 'System.Data.Ol eDb.OleDbExcept ion' occurred in system.data.dll . Some times my code works and some times it doesn't. Its realy wierd. It is erroring on changes = oleDbStaffAdapt er.Update(aData Table) can anyone please help me.
...Code:Private Sub AddBtn_Click(ByVal sender As System.Object, ByVal e As
Leave a comment:
-
Help Deleting from DataBase
Can anyone explain why this code doesnt delete from the database. Some times it works and some times it errors i am confused.
...Code:Private Sub DeleteBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DeleteBtn.Click Dim connStr As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & _ "Data Source = G2G.mdb" Dim oDataTable As New DataTable -
Cheers for all the help i got it to work. I was forgetting to fill the tables using
oleDbStaffAdapt er.Fill(oDataTa ble)Leave a comment:
-
VB Adding to a database
Hi,
I am trying to add to an access database but i keep getting an error saying that the field names i am trying to add to dont exist, but they do. I can connect to the database to search thought it Does any one have any idea of what my problem could be.
[code=vbnet] Private Sub AddBtn_Click(By Val sender As System.Object, ByVal e As System.EventArg s) Handles AddBtn.Click
Dim connStr As String... -
Add Font to Menu Bar
I am new to programming and I need to create a program that changes the font type on the displayed text. To do this i must create a menu bar and have font as a choses next to file. I have generated a menu bar with file but i dont no how to add font to the menu. Can you help please? -
Help DataBinding
Hi Everyone,
as you can see below i have sent data from a Access database to text boxes. I have used DataBinding to do this the problem i have is that databinding is readonly and i want to write to it many times does anyone know of anythink else i can use instead
Dim connStr As String = "Provider = Microsoft.Jet.O LEDB.4.0;" & _
"Data Source = G2G.mdb"
Dim squlStr As String = "SELECT... -
Help Clearing Data in Data Table
I am using the code below to connect to a Access database and the first time roumd it works perfectly but then it errors. I think that the datatable might need clearing but i dont no how to do this. Can anybody tell me ho to solve this problem?? Thanks
Dim connStr As String = "Provider = Microsoft.Jet.O LEDB.4.0;" & _
"Data Source = G2G.mdb"
Dim squlStr As String = "SELECT... -
VB.NET Connecting to a Database
Hi Everyone,
I am working on a assignment for University and i have created a working VB program. I am now conecting a database to this program and am having some problems. I have use the code below to collect data from an Access database and it places the data in a lablebox called StaffLbl but i would like the data to be stored into a string so i then can edit how it is shown in the lable box. Can any one help please.
...
No activity results to display
Leave a comment: