Re: Screen saver - Visual Basic Discussion Boards

First Prev Next

Re: saving treeview changes back in database

Dave Kreskowiak1-Aug-06 5:13

Dave Kreskowiak

1-Aug-06 5:13

The same way you built the treeview from the database. You'll have to walk through each node in the TreeView and build the appropriate SQL statements to update your database properly. There is no standard method to do this. Everything, including tracking which nodes go where, depends entirely on the capabilities you've built into your database.

Dave Kreskowiak
Microsoft MVP - Visual Basic

insert error

kyosugi1-Aug-06 0:17

kyosugi

1-Aug-06 0:17

i trying to add info from user input n submit into the database
i use the insert into
--------------
Private Sub AddSubmitB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddSubmitB.Click
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Jasmine\My Documents\member\db1.mdb"
Dim cmd As New OleDb.OleDbCommand
Dim con As OleDb.OleDbConnection
Dim dr As OleDb.OleDbDataReader

Dim strsql As String
con = New OleDb.OleDbConnection(strcon)
con.Open()

strsql = "Insert into member(BorrowerId, Fname, Lname, Gender, Address1, Address2, Address3) values('" & BorrowerIdTB.Text & "',' " & FnameTB.Text & "',' " & LnameTB.Text & "','" & GenderCLB.Text & "',' " & Add1TB.Text & "','" & Add2TB.Text & "',' " & Add3TB.Text & "')"
cmd.Connection = con
cmd.CommandText = strsql
cmd.ExecuteNonQuery()

con.Close()

MsgBox("Record Added")
Me.Close()

End Sub
--------------
when i run it the debugger stopped at cmd.ExecuteNonQuery()
i seriously duno wat the error is about

Re: insert error

Dave Kreskowiak1-Aug-06 5:18

Dave Kreskowiak

1-Aug-06 5:18

It would help greatly if we knew what the error was!

But, as a suggestion to clean up your code and make it easier to maintain, you might want to look into using parameterize queries instead of this string concantenation mess you've created. This is most likely where your problem is origination from. You can read more about parameterized queries and why they're a much better way to go in Colin Mackay's excellent article here[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

Screen saver [modified]

Sarath C31-Jul-06 23:28

Sarath C

31-Jul-06 23:28

I need to create a screen saver from a text file(where the data to display resides). it would be really helpful if provide some links or tip for the same.

SaRath.

"Where I am from, there is no plan B. So, take advantage of today becuase tomorrow is not promised. - 50 Cent"

My Blog | Understanding State Pattern

-- moved by ed at 8:17 Tuesday 1st August, 2006