|
Glad you got it work 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Dear all,
can anybody tell me how to get sql server version here..
Thanks in advance..
T@SU
|
|
|
|
|
Run the following SQL Query:
SELECT @@VERSION;
This will give you a result similar to this:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4) <br />
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
Thanks for your answer .. now i want
DigiOz Multimedia wrote: 2000
to retrive server year.. as sql 2000 or sql 2005
more pricisly i want to know wheather it is 2000 or 2005 so what is the simple way to do..
Thanks alot..
T@SU
|
|
|
|
|
If you want to do it via SQL have a look at the SERVERPROPERTY('ProductVersion') on MSDN. It wont give you '2000' or '2005' but the major.minor build which you should be able to use to work out the version installed. i.e. 9.x = 2005.
Another way is to use the registry if you want to go down that route but again i believe that will not give you 2000 or 2005 but a major.minor version number.
|
|
|
|
|
SqlCommand cmd = new SqlCommand(@"SELECT @@VERSION", conn);
SqlDataReader myReader = cmd.ExecuteReader()
Console.WriteLine(myReader[0]);
above lines are giving me exact version but they are in the form of string like "
Microsoft sql server 2000 ...."
so i will it be proper to split above string and get 2000 from array[3]
or anyother way can be done here....
T@SU
|
|
|
|
|
I think you should be doing...
SqlCommand cmd = new SqlCommand(@"SELECT SERVERPROPERTY('ProductVersion')", conn);
SqlDataReader myReader = cmd.ExecuteReader()
Console.WriteLine(myReader[0]);
(I havent tested the above code just replaced the sql statement)
That will give you "9.00.xxxx.xx"
Then you can just determine the version using the value 9. So 9 = 2005, 8 = 2000 and you can even go into more detail by easily retrieving the service pack they have installed if you need to.
However if you have to go down the long string route which it seems like you want to then using the array position will work but obviously the biggest flaw is if the strings are in different formats for different versions. (I dont know the answer to that)
Another solution could be using a regular expression to extract a 4 digit string or use the String functions like Contains or IndexOf but this is only useful if you know what you are looking for. i.e. "2000" or "2005".
|
|
|
|
|
Thanks richardson for ur reply...
this is a good idea to get version....
here i am trying to run DTS or SSIS package depending on SQL version..
is there anyother way to run these package without getting version...
Thanks alot.....
vikas da
|
|
|
|
|
Sorry I don't know the answer to that one.
Good luck with it all.
|
|
|
|
|
I have tried to use get the object from Clipboard in OnTimedEvent, it fails
private void OnTimedEvent(object source, ElapsedEventArgs e)<br />
{<br />
try{<br />
IDataObject dataObj = Clipboard.GetDataObject();<br />
if (dataObj != null)<br />
{<br />
MessageBox.Show("Oooops... Got data");<br />
}else<br />
{<br />
MessageBox.Show("No Data~~~ & Timer will be stopped");<br />
<br />
}<br />
}<br />
catch(Exception ex)<br />
{<br />
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
}<br />
<br />
}
Does anyone know how to get data from clipboard triggered by System.Timers.Timer? 
Many Thanks
|
|
|
|
|
You would get it the same way you would any where else in the .Net world. How does "it fail"? Is an exception thrown? If so, what does it say? If no data is returned, are you sure there is data on the clipboard?
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Hi,
I'm doing a printing range option, allow user type the print range like in the Microsoft Word. for example, the range can be (1,2,4-8,10-12)
now, I would like to do a validation, prevent any non-useful character inside this string (i.e. except digit, "," and "-")
any faster way to do this?
Thanks for your help.
|
|
|
|
|
Yes, write a KeyPress event handler for the TextBox.
private void tbPages_KeyPress ( object sender , System.Windows.Forms.KeyPressEventArgs e )
{
if ( "0123456789,-\b".IndexOf ( e.KeyChar ) == -1 )
{
e.Handled = true ;
}
return ;
}
(\b is backspace)
|
|
|
|
|
Thanks so much PIEBALDconsult ~
|
|
|
|
|
|
I have not had the pleasure (or pain as some may see it) of working w/Pointers in C#. However, I remember reading a question someone had asked a few days ago regarding pointers in C# 2005 where they mentioned that in order to use pointers you had to go to the project properties and check the 'Allow Unsafe Code' check box.
Not sure if it'll help, but figured I'd try and give it a shot...
|
|
|
|
|
Yup, you now have to 'Allow Unsafe code' and mark the class / method / block of code as unsafe, like so:
unsafe class myClass
{}
unsafe void myMethod()
{}
static void main(string[] args)
{
unsafe {
}
}
My current favourite word is: Bauble!
-SK Genius
|
|
|
|
|
Hello,
I have a form set up so that it auto-magically resizes its controls when a horizontal splitter is moved. However, when the user resizes the form it is possible for some controls to end up being too small, or pushed out of the form's visible area altogether.
I have found that just a click on the horizontal splitter fixes everything up. So I thought I would just add code to do invoke the splitter in the form's resize event. Only I can't find a way to do that.
Is there a way to fake having the user move the splitter?
Clive Pottinger
Victoria, BC
|
|
|
|
|
Sorry I haven't got an answer but i *HAD* to congratualte you on the word 'auto-magically'!
|
|
|
|
|
DaveyM69 wrote: the word 'auto-magically'!
It's been around since the '70s. See this[^] link, for one.
/ravi
|
|
|
|
|
cpotting wrote: Is there a way to fake having the user move the splitter?
Would an Invalidate() followed by an Update() work instead? Looks like the window needs to be completely refreshed in order for the controls to render properly. This bug is in the Win32 layer and has been around for years. 
/ravi
|
|
|
|
|
Hello, this may be a stupid question but I'm curious. I have a class I've created (that extends the FORM class) that runs as a child form of my main application. The purpose and nature of the form is such that it doesn't matter if it closes...the parent form monitors and will reopen it if necessary. I am handling several types of exceptions and closing the child form when they occur. However, I occasionally get an unhandled exception (in the child form) that causes it to crash.
I'm looking for a way to catch all unhandled exceptions in my custom class and run an event accordingly. Is there a way to do this? I see a method for any unhandled exceptions for the whole app, but I don't want that. I also see how to handle all exceptions when my child form is initialized, but that doesn't help if it's already initialized and running.
All I want now is to handle all exceptions in my custom class. Is this possible?
Thanks,
Alan
|
|
|
|
|
You can put a try block where your form gets started.
<br />
<br />
try<br />
{<br />
Application.Run(new Form1());<br />
}<br />
catch (Exception ex)<br />
{<br />
LogException(ex);<br />
Application.Exit();<br />
}<br />
<br />
|
|
|
|
|
eggs,
thanks for the suggestion! i believe that code will catch any unhandled exceptions generated by my entire app (parent form, and my custom child form). i'm trying to just catch errors in the child form.
the child form is being added something like this:
<br />
frmCustomForm = new MyCustomForm();<br />
<br />
this.Controls.Add(frmCustomForm);
i would like any unhandled exception that occurs within that custom form to cause it to trigger an event.
alan
|
|
|
|
|
Here's an idea of what you could do (although I make no assurances as to the quality of the the design! ) -
In your custom form you'll need to surround any potentially error producing blocks of code in a standard try...catch block. What you'll also need in the custom class is an event, perhaps call it OnError or similar (have a google for how events are implemented in C#), and when an error is caught by the try...catch mechanism, fire off the OnError event.
Then from your main app you can subscribe to this event with something like the following:
{...
frmCustomForm = new MyCustomForm();
frmCustomForm.OnError += new EventHandler(yourMethodHere);
this.Controls.Add(frmCustomForm);
...}
private void yourMethodHere()
{
code that runs when the event is fired an recieved.
}
Now a word of warning It sounds as if there's a lot of logic contained in your custom form that might suit being refactored out... something for you to have a think about!
"On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't.
"I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it."
-Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
