VB6 code convert into C#

Khan Baba

Good day Guys,

I have VB6 Library and Windows Based Application i just want to convert it into C# Language and on C# language i am quite New i just created the SQL Connection string
but if i want to get data in VB6 i use ADOB.Recordset and i use function like this

//VB6 Code for getting MAXID from DATABASE

Public function MaxID(ColName as String, Table as String) as long
Dim recset as ADOB.Recordset
set recset =Conec.Execute("Select max(" & Colname & ")+1 as maxno from " & table

if Not recset.EOF Then
MaxID= iif(isNull(recset ! maxNo), 1 , recset ! maxNo)
Else
MaxID = 1

End If
Set recset= Nothing

End Function

and now i just need that how to convert above VB6 code in C# and one more question that in VB6 we can add Modules where i can save all my Public functions for all forms and in C# how can we use one main file like VB6 help me guys

Thanks in Advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ibrahim Siddique9y ago
Hi,

This will help you ref. below link
http://www.developerfusion.com/tools/convert/vb-to-csharp/
0
Khan Baba9y ago
Thanks bro for your Answer
0
Kailash Polai9y ago
Hi be cool...

I have created some code below as per your two questions, please check it.
//this is the public static class
    public static class MyPublicProperties
    {
        //a property
        public static string SiteName { get; set; }

        //a method
        public static void SetSiteName(string siteName)
        {
            SiteName = siteName;
        }

        public static int GetMaxId(string tableName, string columnName)
        {
            SqlConnection conn = new SqlConnection("your connection string to the database with credentials");
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter("Select max(" + columnName + ")+1 as maxno from " + tableName, conn);
            DataTable dt = new DataTable();
            da.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                return int.Parse(dt.Rows[0][0].ToString());
            }
            else
            {
                return 0;
            }
        }


    }

    //the other class or module
    //you set or get its properties
    public class MyForm : Form
    {
        //initialize code goes here
        //InitializeComponents();


        //your code
        private string GetName()
        {
            return MyPublicProperties.SiteName;
        }

        private void OtherMethod()
        {
            MyPublicProperties.SiteName = "C# Corner";

            //or

            MyPublicProperties.SetSiteName("C# Corner");


            //get new id
            int newId = MyPublicProperties.GetMaxId("TableName", "ColumnName");


        }
    }
Please reply if it was what you need.
+1
Shakti Singh Dulawat9y ago
There are code convertor available in market you can use http://converter.telerik.com/ ,I am mostly using telerik to convert vb.net code to c#
Now for vb6.0 to c# you can use
https://www.codeproject.com/Articles/262950/CodeConverter
OR
http://www.developerfusion.com/tools/convert/vb-to-csharp/

Best way is convert vb 6.0 to vb.net and than c#
+2