[Thinus du Pisanie]

Hi guys I am a vb.net programmer but must do a c# project I have @pieces of code that I don't know how to write in c# and the online converters doesn't work..

For Each m In myq
            txtrole.Text = m.Roles
        Next 

Here I used linq

LunchDataContext cmdatacontext = new LunchDataContext();

 Dim mycheck = From cust In cmdatacontext.tblLogins _
       Where cust.EmployeeName.ToLower = txtuserlogin.Text.ToLower 

If any one can please assist will be nice.

[MrShoes]

For your first piece of code:

foreach (var m in myq)
                txtrole.Text = m.Roles;

I'm not comfotable enough with LINQ to convert your second piece, but a couple of pointers that might help:

• There is no "Dim" keyword in C#. Instead, you declare the variable type, then the name, like int myNumber;
  
• The underscore _ is not used in C# to denote statement continues on the next line. In C#. the semicolon ; denotes the statement has finished, and so the statement can be on any number of lines (although conventions should be followed)

[Skydiver]

Or you can be lazy and say var mycheck if you don't know the the resulting type will be. Let the compiler figure it out for you.

Chances are that you also got a compiler error or warning about cust.EmployeeName.ToLower() = txtuserlogin.Text.ToLower(). You should know that == is the comparison operator, while = is the assignment operator.

[Skydiver]

And as for string comparisons, you should choose ToLower() as your last resort. Your first choice should be String.Compare(..., StringComparison.OrdinalIgnoreCase). You next choice should be String.ToUpperInvariant().

Read about the Microsoft recommendations to avoid the Turkish-I problem: http://msdn.microsof...y/ms973919.aspx

[Thinus du Pisanie]

My vb.net code was this

 Dim mycheck = From cust In cmdatacontext.tblLogins _
       Where cust.EmployeeName.ToLower = txtuserlogin.Text.ToLower

I did this to get to c sharp

dynamic mycheck = from cust in cmdatacontext.tblLogins where cust.EmployeeName..ToLower  = txtuserlogin.Text.ToLower ;

Wich is fine but I get an error saying : "Can not convert string to bool"

Just on the piece saying

cust.EmployeeName..ToLower

[AdamSpeight2008]

LINQ in C# allows requires a Select part, in VB it's optional unless you're doing a transform.

= is assignment is C# you want == equality check.

Plus you have and extra dot.

This post has been edited by AdamSpeight2008: 23 August 2012 - 05:57 AM

[MrShoes]

Try this:

var mycheck = from cust in cmdatacontext.tblLogins where cust.EmployeeName.ToLower()  == txtuserlogin.Text.ToLower() ;

ToLower is a method and must be called as such.

[Thinus du Pisanie]

Sorry MrCupOfT typing error.

D.I.C Head thanks it works no error anymore on the previous piece of code I have errornow on the

 ; 

Saying "A query body must end on a Select clause or a group clause"

So I did it this way

  var mycheck = from cust in cmdatacontext.tblLogins where cust.EmployeeName.ToLower() == txtuserlogin.Text.ToLower() select cust; 

Is this the Select what you meant MrCupOfT ?

[AdamSpeight2008]

Yep.

[Thinus du Pisanie]

Thanks I understand now why... one more thing if you call a setting in vb.net you call it so

 My.Settings.backname = "Bleh" 

and in vb you call a form by

 frmnew_Order .show()

How do you call setting in c# and a form or can you tell my please where I can go search for basic c # knowlede will be very helpful thanks.

[AdamSpeight2008]

Depends
frmnew_Order .show()
if

frmnew_Order is the name of a form not an instance of a form.
In vb.net it will show the default instance. Default Instance I treat with contempt.
If it is a reference it'll show that referenced form.

For Each m In myq
            txtrole.Text = m.Roles
        Next 

Why just write

txtrole.Text = myq.Last().Roles

since you are overwriting the previous one each iteration.

[Thinus du Pisanie]

frmnew_Order .show() 

This is the form name of the form I want to call from a button click event

[AdamSpeight2008]

Then you have to create an instance of that form and show that one, as C# thankful doesn't have default instances.

[Curtis Rutland]

I noticed you used dynamic earlier. I understand you got that from a converter, but I'm going to warn you, any time you need to use dynamic, consider that you might not have come up with the best design.

Dynamic is late-binding. It doesn't give you any type safety, as it will let you store anything at all in it and try to call any method/property/field you want, even if the object doesn't have it. And you won't know until runtime that it didn't work.

Dynamic has some very powerful uses. However, it's usually best to be avoided.

[Thinus du Pisanie]

Ey Curtis Rutland I replaced the Dynamic with Var works better but thanks for the thumps up.