VBA code to C sharp

[atksamy]

HI,

I am trying to convert this code snippet which is in VBA to C sharp. Can someone guide me

Dim cn As New ADODB.Connection, cn2 As New ADODB.Connection
                            Dim rs As ADODB.Recordset
                            Dim rs3 As DAO.Recordset
                            Dim connString As String
                            Dim SelectFieldName
 
                            Set cn = CurrentProject.Connection
                            SelectFieldName = astrFields(intIx)
                            Set rs = cn.OpenSchema(adSchemaColumns, _
                            Array(Empty, Empty, Empty, SelectFieldName))
 
                            'Exclude MS system tables '
                            If Left(rs!Table_Name, 4) <> "MSys" And Left(rs!Table_Name, 4) <> "Abfr" Then
                            strSql = "SELECT t.[" & astrFields(intIx) & "], t.fall from [" & rs!Table_Name & "] t Inner Join 01UMWELT on t.fall = [01UMWELT].fall Where [01UMWELT].Status = 4"
                            End If
 
                            Set rs3 = CurrentDb.OpenRecordset(strSql)

Thanks

[Plater]

Look up using a database in your program.

[targethelpdesk]

Hi there,

A really useful tool for converting VB.NET to C# and back is provided by Telerik at the following url: http://converter.telerik.com/

Hope that helps,

Matt.
http://www.targethelpdesk.com