|
Since we don't know what is on line 138 (which is where your error is) it is going to be difficult to help you pinpoint this.
The code you supply is the constructor for the class, in that constructor you declare a local variable called myConnection, which you initialise and then Open(). The constructor completes the myConnection goes out of scope (in other words it cannot be referenced any more)
Line 138, I can only guess, is outside the constructor and cannot access the local variables within the constructor. If you want to be able to access the variable myConnection from else where in the class you must declare it at the class level and not at the method level.
Does this help?
Cada uno es artifice de su ventura
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
private void button2_Click(object sender, System.EventArgs e)
{
SqlCommand myCommand = new SqlCommand("Command String", myConnection);
}
This is where line 137 , "myConnection" doen not recognized by the compiler 
What can I do
|
|
|
|
|
The reson for the error message is that myConnection is not defined within the current scope. Scope can be simply thought of as the code between the braces { }. As you will have noticed a C# program has lots of opening and closing braces like this...
namespace MyNamespace
{
class MyClass
{
public void MyMethod()
{
for(int i=0;i<100;i++)
{
Console.WriteLine(i.ToString());
}
}
}
}Before each opening brace is some code that explains what the scope is for. e.g. class MyClass or public void MyMethod() to indicate the start of a level of scope.
In your original post you declared myConnection in the constructor, so it was local to the scope of the constructor. What you need to do is declare myConnection in the scope of the class (because you can only see what is in your scope + the parent(s) scope) then you can set value in the constructor.
For example:
namespace MyNamespace
{
class MyClass
{
private SqlConnection myConnection;
public void MyClass()
{
myConnection = new SqlConnection(....);
}
private void button2_Click(object sender, System.EventArgs e)
{
SqlCommand myCommand = new SqlCommand("Command String", myConnection);
}
}
}
Does this help?
Cada uno es artifice de su ventura
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
Thank you for your help and concern...
It helps quite much 
|
|
|
|
|
As Colin pointed out, myConnection is declared in the method scope of th form1 constructor, so is only available within the constructor. Move the declaration outside of the constructor (i.e) public class Form1:...
{
private SqlConnection myConnection = null; //declared at class level scope
form1()
{
myConnection = new SqlConnection(...); //instantiated in constructor
...
}
...
}
Anger is the most impotent of passions. It effects nothing it goes about, and hurts the one who is possessed by it more than the one against whom it is directed.
Carl Sandburg
|
|
|
|
|
Dear CPians...
I have this pattern wich I can't assign to a variable. How can I escpae this:
<\s*DIV((\s*\w*)\s*=\s*("[^"]*"|'[^']'|[^>]*))*>.*<\s*/\s*DIV\s*>
theJazzyBrain
Excellence is not an act, but a habit! Aristotle
|
|
|
|
|
|
thank you .. it works!
theJazzyBrain
Excellence is not an act, but a habit! Aristotle
|
|
|
|
|
Really? How about
string myPattern = @"<\s*DIV((\s*\w*)\s*=\s*("[^"]*"|'[^']'|[^>]*))*>.*<\s*/\s*DIV\s*>";
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yeap,
tried that already but it doesn't work.
There is some problem with these characters :
[
]
these wont escape!
try it out on VS. you will get a
Syntax error, ']' expected
Thank you! :P
theJazzyBrain
Excellence is not an act, but a habit! Aristotle
|
|
|
|
|
Whoops! My bad. The problem is not with the '[' and ']' characters, but with the quotes that I didn't see inside your string. When using the '@' sign in front a a string literal, in order to get a double quote into the string, instead of denoting the end of it, you have to double it up, like:
string myPattern = @"<\s*DIV((\s*\w*)\s*=\s*(""[^""]*""|'[^']'|[^>]*))*>.*<\s*/\s*DIV\s*>";
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yup!
thank you
theJazzyBrain
Excellence is not an act, but a habit! Aristotle
|
|
|
|
|
Dear,
i want to make a lan messenger in C#, HOw?
Awaiting
|
|
|
|
|
You open Visual Studio, create a Windows Forms application project, add whatever UI controls you need to the form, and hang some code on the controls to do the actual processing of your user interface. Oh! You'll also need to add a class to the project and supply the code to pass message back and forth over the network, as well as manage connections to multiple clients, or possibly a chat relay server.
Next question! Maybe being MUCH more specific in scope would help. Like what part of this project are you having problems with?!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dear
i check simple messenger code from site c-sharpcorne.com By Muhammad Al But i didn't able to run it even demo also didn't work if u have more info in this please send me or any link from where i can see about it,
Thanx For +ve Response
|
|
|
|
|
--Using [VS C#.NET]--
Given a main C# form (main.cs Design/Code) and a threaded worker (worker.cs: inherists from a Threaded class that has functions: LockRead and LockWrite implemented)
What I plan on doing is the following:
When the user presses a button I create my new workers as follows (in my main.cs: private void btn1_Click(object sender, System.EventArgs e))
Worker 1Worker = new Worker(Device, File, Task);
Where variables device, File, Task are required information for the worker to perform its task.
Now, my main.cs form also has a Timer (timer_Refresh) that I use to refresh all my GUI (datagrids, combo boxes, etc) so I thought that at this point the timer_Refresh_Tick event could READ the status of the thread and display it in the GUI (is it STRTATING, PROCESSING, FINISHING, etc…)
My main problem is, how to communicate between the main.cs [which has the timer_Refresh_Tick event] and the Worker threads [like 1Worker] to get the status? (shared ressource)
I thought of using a simple array or dataset to store the status of each thread but I can’t seem to figure out how to “share the resource” so that both can access it (and how to implement LockRead and LockWrite accordingly for this resource).
- Worker thread must be able to access it to update its status as it goes
- main.cs timer_Refresh_Tick must be able to access it to read the new status every tick and display it in the datagrid
Using a table/database to store the information is a possibility (creating a [Task] DB Table) and then I will have a Table that both can access [create db connection objects in both] but I am sure there is something way better (like using a custom class…. String[] array…..dataset……?)
I hope this helps show you where I am stuck…
Thanks,
|
|
|
|
|
Hi, everyone,
I have a question when I use the following code to get the response.
WebRequest req = WebRequest.Create(sURL);
try
{
WebResponse result = req.GetResponse();
}
catch(Exception){}
the code works very well on my XP, but when I run it under Windows server 2000, or some others PC, I sometimes get the exception:
The underlying connection was closed: The server committed an HTTP protocol violation.
it comes with the code GetResponse(). But when I use IE try the Url, IE works.
Would you please tell me why that is happened, and How to avoid/fix that, so I can read the response.
Thanks a lot in advance!!
Alan Shen,
Alan Shen
MCAD for .NET Version
^~^~^~^~^~^~^~^~^~^~^
Great idea is the beginging of success!
|
|
|
|
|
If you're sure the code is ok,
1. The .NET Framework versions on XP and Win 2000 server might be different and may cause problems.
2. If it is a specific server you are connecting, it might have a configuration that determines how to response depending on the client-type/platform that is trying to connect.
Just a thought.
Radgar
"Imagination is more important than knowledge." - Albert Einstein
|
|
|
|
|
Can you please help me in my problem?
I have a socket prog. application like
http://www.codeproject.com/dotnet/csharpwhiteboard.asp
My application is chat application like above architecture.
I want to bypass firewall as well as proxy if any on two chat clients like yahoo or msn can chat beyond proxy/firewalls...
Please guide me, how i can do that...!
Thanks,
Mahesh Devjibhai Dhola
"Empower yourself..."
|
|
|
|
|
|
Please tell me how can I send with the message a file and then everything about my question will be clear.Best regards.
|
|
|
|
|
You can't! Code Project doesn't support attachments. But, you can include a link to your code .ZIPped up and posted to some server.
But still, we can look at the code all day long and still not understand your question.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have to compare two XML files in C# by their attribute"name".The key fields are the same
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
