convert VB.net Module to C#

Question

I decided to try out C# for the first time after using VB.net.

Out of curiousity, when I used VB.net I had :

Dim conn As OleDbConnection = New OleDbConnection("Provider=""****"";user id=" & strUserID & ";data source=" & strDatabase & ";password=" & strPssWd)

When trying to convert this format to C# I did the following:

string strAccessConn = "Provider=****;user id=" & strUserID & ";data source=" & strDatabase & ";password=" & strPssWd

However, my strUserId, strDatabase and strPssWd where saved in my Module.vb for VB.net like so:

Module Module1
  Friend strDatabase As String = "****"
  Friend strUserID As String = "****"
  Friend strPssWd As String = "****"

End Module

How do I make the Module in C# (an example would be helpful) Thanks!

FYI: I was told C# Equivalent for VB 'module' was a duplicate.

However the formatting and process of their post isn't equivalent to mine. I am asking a module based on database connection.

@Fruitbat I looked at your duplicate link and it doesn't look like what I have. May be asking the same question but results are not what I need. Sstan's answer was what I need based on my format. So if you downgraded my post then I don't know why. — narue1992
– narue1992, Commented Jul 8, 2015 at 18:11
Not me. I just put the link there because I thought it was what you needed. — Fruitbat
– Fruitbat, Commented Jul 8, 2015 at 18:28
@Fruitbat I see. I just got a "duplicate" alert at top with same link so that is why I asked. Thanks. — narue1992
– narue1992, Commented Jul 8, 2015 at 18:45

sstan · Accepted Answer · 2015-07-08 17:41:13Z

4

You can put constants in a public static class like this:

public static class MyConnectionStringConstants
{
    public const string strDatabase = "****";
    public const string strUserID = "****";
    public const string strPssWd = "****";
}

To use it, you will need to refer to the constants like this:

string strAccessConn = "Provider=****;user id=" + MyConnectionStringConstants.strUserID + ";data source=" + MyConnectionStringConstants.strDatabase + ";password=" + MyConnectionStringConstants.strPssWd

BTW, in C#, you concatenate strings using the + operator, not the & operator.

answered Jul 8, 2015 at 17:41

sstan

36.8k7 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

narue1992 Over a year ago

Thank you for clarification and example. The format of what you sent is exactly similar to my old version. I really appreciate it! I also wasn't fully aware yet that c# uses + so appreciate that information.

Collectives™ on Stack Overflow

convert VB.net Module to C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related