Screen saver [modified] - Visual Basic Discussion Boards

First Prev Next

Re: MsgBox brainteaser

ii_noname_ii2-Aug-06 0:04

ii_noname_ii

2-Aug-06 0:04

Thanx!

Resize OCX in MMC - VB6

YemShivaKumar1-Aug-06 0:38

YemShivaKumar

1-Aug-06 0:38

My problem has to do with an OCX written in VB6, that is being hosted
by the MMC console (in an OCX result view).
How do I resize the OCX so that it fits correctly in the
parent/container? I want the OCX to fill up a portion of the container, and maintain that ratio when the MMC window is resized (or during initial load).
Any thoughts?

Thanks in advance

SivaKumar

Re: Resize OCX in MMC - VB6

Dave Kreskowiak1-Aug-06 5:11

Dave Kreskowiak

1-Aug-06 5:11

Your OCX will have to expose some kind of Resize method. If not, you generally out of luck. You could try hacking around this by searching for the window that the OCX puts up, getting it's handle and then sending the appropriate window messages to get it to resize, but even then, if the support to draw itself using a resizable window is not there, this will all be for nothing.

Dave Kreskowiak
Microsoft MVP - Visual Basic

saving treeview changes back in database

Kapil Thakur1-Aug-06 0:34

Kapil Thakur

1-Aug-06 0:34

i m making a windows application and using treeview control.
i m making the treeview from database.
after doing the editing in text of treeview node.
i want to save the changes back in the database.
how can i do that?

thanx n regardz

kapil

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