How to convert Var from C# to VB?

Question

I found the following C# code which is useful for me:

public partial class Default2 : System.Web.UI.Page 
  { 
    protected void Page_Load(object sender, EventArgs e) 
    { 
        if (Session["EID"] != null) 
        { 
            int EmpID = (int)Session["EID"]; 

            DataClassesDataContext dc = new DataClassesDataContext(); 
            var empInfo = from emp in dc.EmployeeLogins 
                          where emp.EmployeeID == EmpID 
                          select new
                          { 
                                     emp.EmployeeLoginKey, 
                                     emp.EmployeeID, 
                                     emp.username, 
                                     emp.passwd 
                          }; 

           foreach (var v in empInfo) 
           { 
               lblID.Text = v.EmployeeID.ToString(); 
               lblLoginKey.Text = v.EmployeeLoginKey.ToString(); 
               lblPassword.Text = v.passwd.ToString(); 
               lblUserName.Text = v.username.ToString(); 

            } 
       } 
       else 
       { 
           Response.Redirect("Default.aspx"); 
        } 
    } 
}

I had used online converter converted to vb, when I compile the program, it returns an error for the following sentence:

For Each v As var In empInfo

how to convert var from c# to vb?

[VB.NET equivalent to C# var keyword](http://stackoverflow.com/a/2489467/745969) — Tim, Mar 15 '13 at 07:43
Please format your code in future - it's very hard to read with no indentation. — Jon Skeet, Mar 15 '13 at 07:44
what is "empInfo" in statement var empInfo = from emp in dc.EmployeeLogins — Satpal, Mar 15 '13 at 07:47
@SatpalSingh - `empInfo` will be the collection of the anonymous type resulting form the LINQ query. — Tim, Mar 15 '13 at 07:48

MarcinJuraszek · Answer 1 · 2013-03-15T07:49:16.183

2

Just skip type declaration: For Each v In empInfo.

You have to have Option Infer On set.

Formal For Each statement syntax is described on MSDN as following:

For Each element [ As datatype ] In group
    [ statements ]
    [ Continue For ]
    [ statements ]
    [ Exit For ]
    [ statements ]
Next [ element ]

edited Mar 15 '13 at 07:49

answered Mar 15 '13 at 07:44

MarcinJuraszek

124,003
15
196
263

score 0 · Answer 2 · answered Mar 15 '13 at 07:43

0

try with this code:

For Each Dim item In empInfo

answered Mar 15 '13 at 07:43

Mohammad Arshad Alam

9,694
6
38
61

It's not gonna work. `Expression Expected` error is returned. – MarcinJuraszek Mar 15 '13 at 07:47

Christian Hayter · Accepted Answer · 2013-03-15T07:55:58.697

0

For Each v In empInfo

To get VB to infer variable types, just omit the As clause, e.g.

Dim a = b + c

NOTE: This will only work when Option Infer is On. When Option Infer is Off, then variables without type specifiers will default to Object instead.

edited Mar 15 '13 at 07:55

answered Mar 15 '13 at 07:48

Christian Hayter

30,581
6
72
99

score 0 · Answer 4 · answered Mar 15 '13 at 07:56

0

Try with

foreach (Dim v in empInfo) 
                lblID.Text = v.EmployeeID.ToString()
                lblLoginKey.Text = v.EmployeeLoginKey.ToString()
                lblPassword.Text = v.passwd.ToString()
                lblUserName.Text = v.username.ToString()
 Next

Don't forget to add below lines at top of the page

Option Strict On
Option Infer On

answered Mar 15 '13 at 07:56

Rohit Vyas

1,949
3
19
28

You need to enable both `Option Strict` and `Option Infer` to make this work, otherwise the code either will not compile – Rohit Vyas Mar 15 '13 at 07:57
'either will not compile'... or? – Grant Thomas Mar 15 '13 at 08:30

How to convert Var from C# to VB?

4 Answers4