Click here to Skip to main content
15,884,388 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 17:23
WestSideRailways24-Feb-07 17:23 
GeneralRe: SplashScreen Pin
Dave Kreskowiak25-Feb-07 5:42
mveDave Kreskowiak25-Feb-07 5:42 
AnswerRe: SplashScreen Pin
Christian Graus24-Feb-07 16:24
protectorChristian Graus24-Feb-07 16:24 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 17:14
WestSideRailways24-Feb-07 17:14 
GeneralRe: SplashScreen Pin
Christian Graus25-Feb-07 8:57
protectorChristian Graus25-Feb-07 8:57 
AnswerRe: SplashScreen Pin
TwoFaced24-Feb-07 17:46
TwoFaced24-Feb-07 17:46 
GeneralRe: SplashScreen Pin
WestSideRailways24-Feb-07 18:33
WestSideRailways24-Feb-07 18:33 
Questionupdate doesnt save into table using vb.net Pin
7prince24-Feb-07 9:53
7prince24-Feb-07 9:53 
hello,

Does anybody have any idea why update doesn,t save updated fields. Code below runs OK. but doesn't save into CallerRecords table.

I am using VB.NET. thanks.

Here is the code:

Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdate.Click
Dim connectionString As String = "Provider=SQLNCLI;Server=A45292\SQLEXPRESS;DataBase=FSS;Trusted_Connection=Yes"


Dim sqlString As String = "SELECT * FROM CallerRecords Where RecordNo =" & TextBox2.Text


dbConn = New OleDb.OleDbConnection(connectionString)

dbConn.Open()
da = New OleDb.OleDbDataAdapter(sqlString, dbConn)

da.Fill(ds, "CallerRecords")

Dim tbl As DataTable
tbl = ds.Tables("CallerRecords")
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.TextEnd If

Dim myBuilder As OleDbCommandBuilder = New OleDbCommandBuilder(da)

myBuilder.GetUpdateCommand()
da.UpdateCommand = myBuilder.GetUpdateCommand()

da.Update(ds, "CallerRecords")
dbConn.Close()
MessageBox.Show("Database Is Updated")




programmer

AnswerRe: update doesnt save into table using vb.net Pin
Dave Kreskowiak24-Feb-07 11:42
mveDave Kreskowiak24-Feb-07 11:42 
Questiontree view Pin
manni_n24-Feb-07 7:28
manni_n24-Feb-07 7:28 
AnswerRe: tree view Pin
MatrixCoder24-Feb-07 9:12
MatrixCoder24-Feb-07 9:12 
QuestionOleDB error Pin
7prince24-Feb-07 6:31
7prince24-Feb-07 6:31 
AnswerRe: OleDB error Pin
Dave Kreskowiak24-Feb-07 12:12
mveDave Kreskowiak24-Feb-07 12:12 
Questioninsert text data into database (SQL 2005) Pin
lyzaa24-Feb-07 5:22
lyzaa24-Feb-07 5:22 
AnswerRe: insert text data into database (SQL 2005) Pin
TriGiggleMich24-Feb-07 7:48
TriGiggleMich24-Feb-07 7:48 
GeneralRe: insert text data into database (SQL 2005) Pin
lyzaa25-Feb-07 16:37
lyzaa25-Feb-07 16:37 
QuestionRegEx to replace a string [modified] Pin
T John24-Feb-07 3:40
T John24-Feb-07 3:40 
AnswerRe: RegEx to replace a string Pin
The Tigerman24-Feb-07 13:17
The Tigerman24-Feb-07 13:17 
GeneralRe: RegEx to replace a string Pin
T John25-Feb-07 4:36
T John25-Feb-07 4:36 
QuestionHow do you open an Access Query in Excel using a vb button? Pin
China-Gary24-Feb-07 2:09
China-Gary24-Feb-07 2:09 
QuestionCan a form have a scroll bar? Pin
steve_rm24-Feb-07 1:35
steve_rm24-Feb-07 1:35 
AnswerRe: Can a form have a scroll bar? Pin
JUNEYT24-Feb-07 2:10
JUNEYT24-Feb-07 2:10 
AnswerRe: Can a form have a scroll bar? Pin
manni_n24-Feb-07 2:22
manni_n24-Feb-07 2:22 
AnswerRe: Can a form have a scroll bar? Pin
Guffa24-Feb-07 3:41
Guffa24-Feb-07 3:41 
AnswerRe: Can a form have a scroll bar? Pin
steve_rm24-Feb-07 3:53
steve_rm24-Feb-07 3:53 

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.