VB6 code convert into C#

Question

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

Kailash Polai · Answer

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.

Shakti Singh Dulawat · Answer

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#

Ibrahim Siddique · Answer

Hi This will help you ref. below link http://www.developerfusion.com/tools/convert/vb-to-csharp/

Khan Baba · Answer

Thanks bro for your Answer