|
Hi!
I am working on a desktop application in C#. I'd like to show a small icon whether the user has still access to the database or not. Therefore I try to open a connection periodically (timer tick event every 10 sec). When I tested this application something strange happened
1) sql service not running -> I started application -> con.open fails -> catch block -> show disconnect icon
2) i started sql service -> con.open works -> show connect icon
3) i stopped sql service -> con.open STILL works??? -> no exception????
Below you can see my code.
Thread t = new Thread(delegate()
{
SqlConnection con = null;
try
{
string conStr = "CONNECTIONSTRING GOES HERE";
con = new SqlConnection(conStr);
con.Open();
datenbankStatus(true);
}
catch (Exception ex)
{
datenbankStatus(false);
}
finally
{
if (con != null && con.State == System.Data.ConnectionState.Open) con.Close();
}
});
t.IsBackground = true;
t.Start();
Any help would be great!!
Thx in advance
|
|
|
|
|
I have an india map(single image).In that map if i click on Andhra pradesh it should show that Andhra Pradesh Map. please help me for this work. i want this application in c# windows application.
|
|
|
|
|
|
sorry this not suitable to my question.is there any other examples to find out the regions of a single image.
|
|
|
|
|
Hi everyone, I have a big problem I can't manage to solve.. This is the explanation: I have two windows form projects. The first one is needed only to output a .cs file, with inside parameters given by the user. And thi is ok. The generated .cs file should be the code file for the other windows form application. And this is also ok. Now I need to compile the project from the first application, and this is what's missing. Any advice? I tried to use the CodeDom, but I just could manage to create a console application,like in the example given in the msnd documentation. Thanks Bye Gabri
|
|
|
|
|
Now what is the problem you are experiencing? Cant you just add an entry in the second project for the generated file?
|
|
|
|
|
Hmm
I think I explained it bad, or perhaps I couldn't understand your answer..
I try to explain better the problem:
First application generates the .cs file and puts it in the second application folder. First application in still running. Now First application should compile the second application in an .exe file.
I just can't understand how to do this.
With CodeDom I understood how to create a simple console application, but it isn't what i need, my second application should be a windows form application.
If your answer was right, can you explain it better to me?
Thanks anyway for the answer!
|
|
|
|
|
Ok, I understand a bit better. The best choice IMO is to utilize MSBuild. The first application will call MSBuild on the seconds project file after the first project has generated the C# file.
You can call MSBuild either via code (hard) or just as a process (easy).
|
|
|
|
|
Yes, it seems to be the solution!
Ok, last two questions..
1)Have you ever used it? A little little explanation of how it works is possible?
2)What do you mean with "via code (hard) or just as a process (easy)."
Thanks again!
|
|
|
|
|
kontax wrote: 1)Have you ever used it? A little little explanation of how it works is possible?
Yes. Just type in 'msbuild /?' to get all the options. There are MSDN docs too, Google for a few tutorials to get the hang of it. VS uses it internally.
kontax wrote: 2)What do you mean with "via code (hard) or just as a process (easy)."
via code: Reference the MSBuild assembly (not sure about the name now), and call the method via code.
via process: Process.Create("msbuild ...")
|
|
|
|
|
|
|
Yes,i tried that way. But I understood only how to compile a source files. I could just compile from a .cs file to a .exe file. I need to compile a project made from a form and its .cs file together in an executable file.
Is there a workaround to do this with CodeDom or CSharpProvider?
|
|
|
|
|
If you put your form's designer generated code and the cs file into one file then you can compile it using CSharpProvider, but you can't compile a project.
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
|
With CSharpProvider you have to programmatically add referenced assemblies. Did you have a look at the link I provided?
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Yes I did.. and it's a really good article!(I also didn't know how to drag files..)
I'd seen you used the CSharpProvider, i just thought it could be possible also with CodeDom like i did, cause I used it to compile other kind of .cs files.
Ok, I'll switch to the CSharpProvider..
THANKS for everything!
bye
|
|
|
|
|
You are welcome 
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
Hey
I have a textbox with values = 1 + 1,3 + 1 + 7
How can i calculate that so when i push the button calculate will give the result = 10,3
Thanks very very mutch
its really importing
|
|
|
|
|
|
AFAIK, this things are done by converting the arithmetic expression to it's postfix form. Do some reading on that.
|
|
|
|
|
thaks very mutch but you do not have som method like double.parse(textbox.text) or somthing like that som can help me out of here.
I used Inof.Lundin.Math but this cannon add decimal this can just add 1+1 = 2 but not 1+1,4 = 2,4
|
|
|
|
|
Just out of curiosity I downloaded the library you mentioned and it works for me. This is my small test:
info.lundin.Math.ExpressionParser exp = new info.lundin.Math.ExpressionParser();
Hashtable h = new Hashtable();
h.Add("x", "1");
h.Add("y", "1,5");
h.Add("z", "0,23");
double result = exp.Parse("x + y + z", h);
MessageBox.Show(result.ToString());
The result is 2,73 -just as expected.
EDIT:
If you want to take the expression directly from a textbox, use this code:
info.lundin.Math.ExpressionParser exp = new info.lundin.Math.ExpressionParser();
Hashtable h = new Hashtable();
double result = exp.Parse(myTextBox.Text, h);
MessageBox.Show(result.ToString());
This also works for me. However (just a guess), you might get that error because you are using incorrect decimal separator for your culture. On my machine the comma is the separator, but for you it might be the dot. Check it.
|
|
|
|
|
Thanks very mutch blackjac
But it still not work if i use dot ex. 1.4 then it takes it like 14 and if i use 1,4 coms with error
"No value associated with 1,4"
|
|
|
|
|
2,4 is not a valid decimal/floating-point-number in most cultures.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
