Click here to Skip to main content
15,905,071 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 9:30
alexfromto22-Feb-07 9:30 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:59
mveDave Kreskowiak22-Feb-07 9:59 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 10:40
alexfromto22-Feb-07 10:40 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 11:57
mveDave Kreskowiak22-Feb-07 11:57 
QuestionDisplaying forms Pin
jady8422-Feb-07 7:17
jady8422-Feb-07 7:17 
AnswerRe: Displaying forms Pin
Dave Kreskowiak22-Feb-07 8:38
mveDave Kreskowiak22-Feb-07 8:38 
AnswerRe: Displaying forms Pin
TwoFaced22-Feb-07 9:10
TwoFaced22-Feb-07 9:10 
QuestionOleDB error Pin
7prince22-Feb-07 7:10
7prince22-Feb-07 7:10 
Hello,

I am getting following error when hit the update button.

No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).

Any idea Why? thanks.

here is my 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=sqloledb;Data Source=A45292\SQLEXPRESS;Initial Catalog=FSS;Integrated Security=True"

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
End If
dataAdapter.Update(data, "Caller Records")
dbConn.Close()


programmer

AnswerRe: OleDB error Pin
Dave Kreskowiak22-Feb-07 8:36
mveDave Kreskowiak22-Feb-07 8:36 
GeneralRe: OleDB error Pin
7prince22-Feb-07 12:55
7prince22-Feb-07 12:55 
QuestionHow to avoid serialization of events Pin
Bergerrudi22-Feb-07 5:51
Bergerrudi22-Feb-07 5:51 
AnswerRe: How to avoid serialization of events Pin
nlarson1122-Feb-07 5:59
nlarson1122-Feb-07 5:59 
GeneralRe: How to avoid serialization of events Pin
Dave Kreskowiak22-Feb-07 6:10
mveDave Kreskowiak22-Feb-07 6:10 
GeneralRe: How to avoid serialization of events Pin
nlarson1122-Feb-07 6:19
nlarson1122-Feb-07 6:19 
AnswerRe: How to avoid serialization of events Pin
Dave Kreskowiak22-Feb-07 6:06
mveDave Kreskowiak22-Feb-07 6:06 
GeneralRe: How to avoid serialization of events Pin
Bergerrudi23-Feb-07 0:36
Bergerrudi23-Feb-07 0:36 
Questionstring to DateTime Conversion Pin
Jonathan Gibbs22-Feb-07 4:17
Jonathan Gibbs22-Feb-07 4:17 
AnswerRe: string to DateTime Conversion Pin
Stefan Troschuetz22-Feb-07 7:44
Stefan Troschuetz22-Feb-07 7:44 
GeneralRe: string to DateTime Conversion Pin
Jonathan Gibbs23-Feb-07 2:57
Jonathan Gibbs23-Feb-07 2:57 
QuestionCheck fields for specific characters Pin
rhon_ridge22-Feb-07 3:15
rhon_ridge22-Feb-07 3:15 
AnswerRe: Check fields for specific characters Pin
nlarson1122-Feb-07 6:01
nlarson1122-Feb-07 6:01 
QuestionWhen to close streamreaders/writers Pin
Marcus J. Smith22-Feb-07 3:12
professionalMarcus J. Smith22-Feb-07 3:12 
AnswerRe: When to close streamreaders/writers Pin
Dave Kreskowiak22-Feb-07 5:05
mveDave Kreskowiak22-Feb-07 5:05 
GeneralRe: When to close streamreaders/writers Pin
Marcus J. Smith22-Feb-07 5:21
professionalMarcus J. Smith22-Feb-07 5:21 
GeneralRe: When to close streamreaders/writers Pin
Dave Kreskowiak22-Feb-07 5:25
mveDave Kreskowiak22-Feb-07 5:25 

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.