|
Why are you using MsgBox and not the MessageBox?
Select Case MessageBox.Show("Are you sure you want to delete this learning?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)<br />
Case Windows.Forms.DialogResult.Yes<br />
'Yes code here<br />
Case Windows.Forms.DialogResult.No<br />
'No code here<br />
End Select
Easier to read, and uses the .NET messagebox rather than the VB6- legacy MsgBox
Steve Jowett
|
|
|
|
|
I get "name MessageBox not declared" :s
|
|
|
|
|
Imports System.Windows.Forms
Thank should sort it.
Steve Jowett
|
|
|
|
|
Thanx!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
|
|
I already searched... after that posted here :P
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
|
|
|
|
|
|
I think your link is misleading. it's going to one of my post at code project
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
|
|
|
|
|
probably its not misleading it is telling you that just some time back you told some that not to put programming question here and you yourself are putting it here.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Ok. If you are considering this as programming question, nothing I can do...
:P
|
|
|
|
|
No offence intended but it is certainly a programming question.
Best Regards,
Apurva Kaushal
|
|
|
|
|
apurva kaushal wrote: No offence intended but it is certainly a programming question.
No offence intended, but it is certainly not a programming question.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ryan Binns wrote: No offence intended, but it is certainly not a programming question.
Hey Sandgroper, how about a little bit more information on why it isn't a programming question?
Never mind, seems I've already done that for you.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|
|
Because he said it wasn't. He specifically said he wasn't wanting to write one, but wanted one that was already written.
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ryan Binns wrote: Because he said it wasn't. He specifically said he wasn't wanting to write one, but wanted one that was already written.
You must have missed my cunning and wry New South Wales sarcasm. I also mentioned I had done it for you. Just was too lazy to get a link to my reply which was immediately below yours.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|
|
Michael Martin wrote: You must have missed my cunning and wry New South Wales sarcasm. I also mentioned I had done it for you.
Heh. I just automatically assume you eastern-states folks are insulting us westerners at every possible opportunity. It's rare that that's not the case
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
apurva kaushal wrote: No offence intended but it is certainly a programming question.
Rat's arse it is. He didn't ask how to do it, nor for anyone to provide code, just links to where he can find the answers himself. Well within the parameters of Lounge usage.
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash 24/04/2004
|
|
|
|