Visual Basic

Re: vb6 migration to .net

24-Jun-08 2:51

Visual Studio tries, but I don't know of any better tools. VB6 -> VB.NET is two different languages, some rewrite will always be needed.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Chaitanya kumar CVSS25-Jun-08 2:59

Chaitanya kumar CVSS

25-Jun-08 2:59

Hi
I too doing the same job ..I didn't find any tool for this conversion.
Try to open the VB6 project file with the Visual Studio,it will ask for upgrade option
It will upgrade some code and leaves a message over the code where it fails.

Happy coding..

converting from SQL server to MySql

ttilque24-Jun-08 1:49

ttilque

24-Jun-08 1:49

We have a system that we want to switch from SQL server to MySql. Is there a simple way to do that. I thought maybe we could just change the connection string in our app.config file but that does not seem to work.

Any and all advice welcome.

Thanks
Tom

Christian Graus24-Jun-08 1:53

24-Jun-08 1:53

If that doesn't work, you've used SQL that's specific to SQL Server, or you've used the SQL Server specific classes and need to move to the OleDB ones. Hard to know without you telling us what 'does not seem to work', means.

jzonthemtn24-Jun-08 6:38

jzonthemtn

24-Jun-08 6:38

You may find the MySql Connector/Net[^] to be useful. Just replace your SqlClient references with the new references for MySql. And as Christian said in his reply to you, as long as you did not use any SQL Server-specific commands you will be good to go.

ttilque24-Jun-08 10:42

ttilque

24-Jun-08 10:42

OK.. Pardon my ignorance please.. but what do you mean by replace SqlClient references with the new references for Mysql. Can you give me a example ?

Thanks in advance
Tom

jzonthemtn24-Jun-08 10:54

jzonthemtn

24-Jun-08 10:54

Sure. This is probably how your code using SQL Server looks:

Imports System.Data.SqlClient

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim DatabaseConnection As New SqlConnection("connectionstringgoeshere")

        DatabaseConnection.Open()

        Dim SQLCommand As New SqlCommand("SELECT * FROM TABLE", DatabaseConnection)
        SQLCommand.ExecuteNonQuery()

        DatabaseConnection.Close()

    End Sub

End Class

Now, after you have downloaded and installed the MySql Connector/Net, open the project's properties, click References, click Add, and add C:\Program Files\MySQL\MySQL Connector Net 5.1.6\Binaries\.NET 2.0\MySql.Data.dll. That's the default directory, it may be somewhere else on your computer. Next, change your code to MySql. I bolded the changes:

Imports MySql.Data.MySqlClient

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim DatabaseConnection As New MySqlConnection("connectionstringgoeshere")

        DatabaseConnection.Open()

        Dim SQLCommand As New MySqlCommand("SELECT * FROM TABLE", DatabaseConnection)
        SQLCommand.ExecuteNonQuery()

        DatabaseConnection.Close()

    End Sub

End Class

Again referring back to what Christian said earlier, as long as you don't do any SQL Server-specific queries you should pretty much be able to just replace the SQL Server stuff with the MySql stuff. Make sure to update your connection string to be for MySql. (You can also use OleDbConnection if you don't want to use the MySql Connector.)

Hope this helps...

Need to open an image file, like jpg ?

ttilque25-Jun-08 3:22

ttilque

25-Jun-08 3:22

I am using tableadapters built from the data source so I can't just replace the sql server commands with the mysql commands. I guess I thought I should be able to just change the
connectionstring and provider name in my config file and it would go to the MySql database.

Tom

masoodp66624-Jun-08 1:33

masoodp666

24-Jun-08 1:33

Hi I want to open a jpg file from calling with button and the image load with windows picture or somthing else.

please help. tanx!

Christian Graus24-Jun-08 1:53

24-Jun-08 1:53

Bitmap.FromFile

masoodp66624-Jun-08 3:55

masoodp666

24-Jun-08 3:55

please more explanation with complete code.
thank U

Christian Graus24-Jun-08 11:33

24-Jun-08 11:33

I see someone posted it. I recommend you read the article I link to in my sig, buy a book on VB.NET and learn some basics so you have a basis on which to understand answers given to you. If you can't work things out based on being told what method to call, you're probably just cutting and pasting code you're given but don't understand, and that's not how to learn.

Outlook COM Addin deployment on Terminal server

Karrar Ketawi24-Jun-08 10:29

Karrar Ketawi

24-Jun-08 10:29

ViewPictureBox.Image = System.Drawing.Bitmap.FromFile("here is your image path")

Primary Key checking

rrrriiizz24-Jun-08 1:13

rrrriiizz

24-Jun-08 1:13

Hello All,
I want to check a simple think in the database ie i want to check the particular data is already in the database or not. Particular table contain only one field and that field is only a primary key. i want to check it with my frond end that is visual studio.net 2008
I write the below code for that

rs.Open("select * from CategoryMaster where categoryname = '"&txtcat.Text &"'", con, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic)
If rs.EOF Then
rs.AddNew()
rs.Fields("CategoryName") = txtcat.Text
rs.Update()
txtcat.Text = ""
txtcat.Focus()
Else
MsgBox("This category is Already in database ")
End If

I that code it shown some error in the below line
rs.Fields("CategoryName") = txtcat.Text

The error is Property 'Item' is 'ReadOnly'

Please help me to resolve this Cry | :((

Thanks

Re: Primary Key checking

Marek Grzenkowicz24-Jun-08 3:10

Marek Grzenkowicz

24-Jun-08 3:10

Try: rs.Fields("CategoryName").Value = txtcat.Text.

Re: Primary Key checking

rrrriiizz24-Jun-08 18:27

rrrriiizz

24-Jun-08 18:27

Absoulutely. thankyou so much.

manisghouri24-Jun-08 0:45

Re: Outlook COM Addin deployment on Terminal server

24-Jun-08 0:45

Hi All, I recently developed a shared COM Addin using VB.Net and Outlook 2003. It works great on local machine but when I install it on Terminal server it doesn't work.

My Addin get installed on Windows 2003 Terminal server with the initial Loadbehavior = 2Hex value under the HKEY_LOCAL_MACHINE in registry. It starts working when I change it to 3Hex. But as soon as another user logs in on termail server and starts outlook, the loadbehavior values becomes 2Hex again and my Addin stops working for all users.

Any idea why registry is being changed by multiple user sessions. I will appreciate your response.

Thanks

~Khatri Mitesh~24-Jun-08 1:57

~Khatri Mitesh~

24-Jun-08 1:57

Hiii Expert
I m also working on outlook 2003 add ins using vb.net 2005. and i am facing same problem but i solved my problem following these steps (MSDN Article).

http://msdn.microsoft.com/en-us/library/aa537179(office.11).aspx

May be this helps you.
Thanx
Mitesh Khatri

Re: Outlook COM Addin deployment on Terminal server

manisghouri24-Jun-08 2:48

Re: Outlook COM Addin deployment on Terminal server

24-Jun-08 2:48

Hey Mitresh, Many thanks for your response. My Addin is a Shared Addin not VSTO one, do you think these steps are same for shared addin?

Nas

manisghouri24-Jun-08 7:47

Re: Outlook COM Addin deployment on Terminal server

24-Jun-08 7:47

Hi, I did follow the article but still same problem. I guess this article addresses VSTO Addins not Shared COM Addins. Just for the test purpose, I created a small shared COM addin for outlook 2003. After installation it worked fine but as soon 2 users started outlook session (on Terminal server), it stoped working and again Registry Loadbehavior value changed to 2 from 3. This thing is driving me crazy. Does anyone guide me where I am wrong?

Thanks

~Khatri Mitesh~24-Jun-08 19:56

~Khatri Mitesh~

24-Jun-08 19:56

Hiii
I also develop excel 2007 Shared add ins and when i run multiple instance of excel then my add in not working properly on same machine. i think add ins working on single instance of a application.
Thanx
Mitesh Khatri

Re: Outlook COM Addin deployment on Terminal server

manisghouri25-Jun-08 7:38