Click here to Skip to main content
15,881,803 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n23-Feb-07 8:32
manni_n23-Feb-07 8:32 
GeneralRe: incluiding calculator in my vb.net application Pin
Christian Graus23-Feb-07 10:04
protectorChristian Graus23-Feb-07 10:04 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n23-Feb-07 12:35
manni_n23-Feb-07 12:35 
GeneralRe: incluiding calculator in my vb.net application Pin
Vikash Yadav23-Feb-07 22:24
Vikash Yadav23-Feb-07 22:24 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n24-Feb-07 1:01
manni_n24-Feb-07 1:01 
Questionconversion from vb.net to vb Pin
manni_n23-Feb-07 7:01
manni_n23-Feb-07 7:01 
AnswerRe: conversion from vb.net to vb Pin
Dave Kreskowiak23-Feb-07 7:31
mveDave Kreskowiak23-Feb-07 7:31 
Questionvb.net error Pin
7prince23-Feb-07 6:02
7prince23-Feb-07 6:02 
Hello,

I am using Vb.NET

Does anyone have any idea why I am getting the following error at the line where it says: dataAdapter.Update(data, "Caller Records")

Error message is:
Incorrect syntax near 'Records'.

Here is the full code:

Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdate.Click

Dim data As New DataSet
Dim dbConn As OleDb.OleDbConnection

Dim dataAdapter As OleDb.OleDbDataAdapter

Dim connectionString As String = "Provider=SQLNCLI;Server=A45292\SQLEXPRESS;DataBase=FSS;Trusted_Connection=Yes"

Dim sqlString As String = "SELECT * FROM [Caller Records] Where RecordNo =" & TextBox2.Text

dbConn = New OleDb.OleDbConnection(connectionString)
dataAdapter = New OleDb.OleDbDataAdapter(sqlString, dbConn)

dataAdapter.Fill(data, "Caller Records")

Dim tbl As DataTable
tbl = data.Tables("Caller Records")
Dim selectedRows() As DataRow

selectedRows = tbl.Select("RecordNo = " & TextBox2.Text)

If selectedRows.Length > 0 Then
selectedRows(0).Item("FirstName") = FirstNameTextBox.Text
selectedRows(0).Item("LastName") = LastNameTextBox.Text
selectedRows(0).Item("CallerPhone") = CallerPhoneTextBox.Text
selectedRows(0).Item("HospitalNumber") = TextBox1.Text
selectedRows(0).Item("Type") = TypeTextBox.Text

End If

Dim myBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(dataAdapter)

myBuilder.GetUpdateCommand()
dataAdapter.UpdateCommand = myBuilder.GetUpdateCommand()
dataAdapter.Update(data, "Caller Records")

MessageBox.Show("Database Is Updated")
dbConn.Close()





programmer

AnswerRe: vb.net error Pin
kubben23-Feb-07 6:07
kubben23-Feb-07 6:07 
GeneralRe: vb.net error Pin
7prince23-Feb-07 6:18
7prince23-Feb-07 6:18 
GeneralRe: vb.net error Pin
kubben23-Feb-07 6:47
kubben23-Feb-07 6:47 
GeneralRe: vb.net error Pin
7prince23-Feb-07 6:58
7prince23-Feb-07 6:58 
AnswerRe: vb.net error Pin
Dave Kreskowiak23-Feb-07 7:28
mveDave Kreskowiak23-Feb-07 7:28 
QuestionAdding listbox items to an Access DB Pin
China-Gary23-Feb-07 6:00
China-Gary23-Feb-07 6:00 
AnswerRe: Adding listbox items to an Access DB Pin
JUNEYT23-Feb-07 6:50
JUNEYT23-Feb-07 6:50 
QuestionImplementing some broadcast udp protocol Pin
ohad_2923-Feb-07 3:30
ohad_2923-Feb-07 3:30 
AnswerRe: Implementing some broadcast udp protocol Pin
nlarson1123-Feb-07 7:55
nlarson1123-Feb-07 7:55 
GeneralRe: Implementing some broadcast udp protocol Pin
ohad_2924-Feb-07 10:28
ohad_2924-Feb-07 10:28 
GeneralRe: Implementing some broadcast udp protocol Pin
nlarson1124-Feb-07 15:10
nlarson1124-Feb-07 15:10 
QuestionMemory of String Pin
Kumaran21cen23-Feb-07 2:40
Kumaran21cen23-Feb-07 2:40 
AnswerRe: Memory of String Pin
Colin Angus Mackay23-Feb-07 4:20
Colin Angus Mackay23-Feb-07 4:20 
Questionsearch for a word inside a .doc file Pin
digitaldxb23-Feb-07 1:19
digitaldxb23-Feb-07 1:19 
AnswerRe: search for a word inside a .doc file Pin
Dave Kreskowiak23-Feb-07 5:48
mveDave Kreskowiak23-Feb-07 5:48 
GeneralRe: search for a word inside a .doc file Pin
digitaldxb23-Feb-07 6:55
digitaldxb23-Feb-07 6:55 
GeneralRe: search for a word inside a .doc file Pin
Dave Kreskowiak23-Feb-07 7:19
mveDave Kreskowiak23-Feb-07 7:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.