I am not good in c# plz help to change the following code into c# syantaxxxx









NRecords = oEmployee.NumberOfRecords
If NRecords > 0 Then
For I = 1 To NRecords
With Worksheets(SHEETNAME)
myColumn = Range(StartCell).Columns.Column
Application.StatusBar = "Reading employee " & I & " of " & NRecords
.Cells(myRow, myColumn) = oEmployee.EmployeeID(I)
myColumn = myColumn + 1
s = oEmployee.EmployeeLastName(I) & ", " _
& oEmployee.EmployeeFirstName(I) & " " _
& oEmployee.EmployeeMiddleInitial(I) & "."
.Cells(myRow, myColumn) = s
myColumn = myColumn + 1
.Cells(myRow, myColumn) = oEmployee.AddressLine1(I)
.Cells(myRow, myColumn + 1) = oEmployee.SocialSecurityNumber(I)
.Cells(myRow, myColumn + 2) = oEmployee.Telephone(I)
.Cells(myRow, myColumn + 3) = YesNo(oEmployee.SalesRep(I))
myRow = myRow + 1
s = oEmployee.AddressLine2(I)
If (s <> "") Then
.Cells(myRow, myColumn) = s
myRow = myRow + 1
End If
.Cells(myRow, myColumn) = oEmployee.City(I) _
& ", " & oEmployee.State(I) _
& " " & oEmployee.Zipcode(I)
myRow = myRow + 2


End With
Next I
End If
Application.ScreenUpdating = True
Status = oEmployee.CloseData
End If

Done:
Set oEmployee = Nothing
Application.StatusBar = ""

End Function

plz help