declaration expected vb.net

Question

0.00/5 (No votes)

See more:

How to declare a variable?

VB

Imports System.Data.OleDb
Public Class Form1
    Public constring1 As String
    constring1 = "Provider=MSDAORA.1;Password=temp;User ID=temp;Data Source=orcl1;Persist Security Info=True"

End Class

Here constring1 is showing error: Declaration expected

Please help.

Posted 23-Jan-14 23:46pm

dbhaskar

Updated 24-Jan-14 0:03am

Pete O'Hanlon

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Answer 1 · 2014-01-24T00:01:00

Solution 1

You don't have your string allocation inside any method though. You want to do this:

VB

Public constring1 As String = "Provider=MSDAORA.1;Password=temp;User ID=temp;Data Source=orcl1;Persist Security Info=True"

Posted 24-Jan-14 0:01am

Pete O'Hanlon

Gregory Gadow · Answer 2 · 2014-01-24T04:09:00

You can declare variables at the class scope, but you cannot actually do anything at that level. So you do what Pete said, and make the assignment in the declaration.

BUT... it is generally a bad practice to declare public variables at the class scope. If this is a constant -- it is available for use but will never be changed -- add the Const keyword, like so:

VB

Public Const constring1 As String = "Provider=MSDAORA.1;Password=temp;User ID=temp;Data Source=orcl1;Persist Security Info=True"

Constants are kept in a separate section of memory where they are not subjected to things like garbage collection. This will also protect the value from being tampered with, either deliberately or accidentally. Const also adds an implicit Shared to the declaration, meaning you would access it by using the class name -- Form1.constring1 -- rather than by using an instance.

Since you are declaring this on a form, which presumably will be not be used as a class, why make it Public at all? A good rule of thumb in Object Oriented Programming is to expose only those elements that need to be exposed. If the string will be used only internally, declare it to be Private, or Protected if you will be using your form as a base class for other forms.

Abhinav S · Answer 3 · 2014-01-24T06:03:00

Solution 3

You might want to pickup reading from the basics - http://msdn.microsoft.com/en-us/library/aa290387%28v=vs.71%29.aspx[^].

Posted 24-Jan-14 6:03am

Abhinav S