|
Thanks Dave
Yes I am beginning to wonder. I have to go on what he tells me, but of course I cannot confirm. I will call this a day here as I am sure the problem lies with the user.
Many thank for your assistance.
|
|
|
|
|
Hi,
What do I need to do display on a form my
1..My default printer
2..List of all my printers
Basically what reference do I need to import to get my printer properties.
P.S. Any sample code would be greatly appreciated.
|
|
|
|
|
An explicit list of printers is available through PrinterSettings.InstalledPrinters
.NET has some classes that help you with most aspects of printing. One often only needs PrintDialog and PrintDocument. If that is not sufficient, get ready for quite some complexity (maybe caused by how it all grew over time.
|
|
|
|
|
See here[^].
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
|
Say goodbye to your spam post...
|
|
|
|
|
Voted to remove becouse advertising is not allowed in these forums.
|
|
|
|
|
You tell him, Tiger!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
ANd this has WHAT to do with VB.NET??
|
|
|
|
|
Hi,
How can I search for codes represent data type decimal(18,2)?
Have a code_textbox and search_button on a form.
have a query to seach code:
select * from commune_table
where (code=@code)
when I put value such as 2.02 no result yet the record is in the table correctly.
Thanks a lot!
|
|
|
|
|
You need to know that most real numbers (float, double) cannot be represented exactly using binary representations. So what is present in the database might well be 2.0199999976 which may be shown by some software as 2.02 but does not exactly equal 2.02
One way of getting around that problem is by not looking for an exact value, look for a range instead (say anything between 2.019 and 2.021). Another way, which I do not recommend, is by converting to string and chopping/rounding, then comparing.
|
|
|
|
|
Hi,
In the table code column shows values as 2.01,2.02 etc..
but if I pass a query for 2.01, I get no returned value.
again code data type as decimal(18,2)
thanks again..
|
|
|
|
|
and how do you pass your value (2.01 or 2.02) so that it ends up in @code?
is everything on its way a decimal, or are some non-exact floats/singles/doubles/reals used in the process?
|
|
|
|
|
Hi,
from a form in a textbox..you can simply in the value, it gets to table as you enter it
thanks
|
|
|
|
|
that is not answering my question.
without getting detailed answers or seeing all the relevant actual code I can't help you.
I repeat: reals/floats/singles/doubles anywhere in your path will cause inexact values in binary.
|
|
|
|
|
|
You should try reading his answer, before you post a new "hint" with a thankyou and hoping that Luc will post the correct code.
You're welcome
I are Troll 
|
|
|
|
|
Now that you had a day's worth of time, try the statement below;
declare @code float
set @code = 2.435
declare @upperBound float
declare @lowerBound float
set @upperBound = @code + .01
set @lowerBound = @code - .01
select *
from commune_table
where code between @lowerBound and @upperBound
The database doesn't store the number "2.1", it stores a number that matches it very closely. That means that if you want to search for such a value, that you'd have to take a margin in account. No, this is not a simple solution to your problem, as you simply cannot search for a fractional number in the database the way you'd search for a string.
I are Troll
|
|
|
|
|
Hi,
In this case, what can I do?
the code list shows as 2.01,2.02
the end user needs to simply search for code from the list.
How can I achieve that..
Or if code represents as 2.0, 2.1,2.2,...2.10, 2.11, etc..what data type to use and would that aid my situation?
thanks..
|
|
|
|
|
I had about a year to find a way to disable ctrl + alt + del in windows vista & 7 in google, but until now I have not got it. Does anyone here know the code? Any help greatly appreciated. Thank you!
modified on Wednesday, January 5, 2011 6:26 AM
|
|
|
|
|
Are you after stopping people from pressing that combo in your application or to stop the windows combo?
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
|
It's a reserved combination, not meant to be disabled. A standard application cannot intercept the combination out of security-reasons.
I have yet to hear a good reason to disable that particular combination.
I are Troll
|
|
|
|
|
This may be done in windows xp. Is it because in windows xp this combination key just to bring up windows task manager? While on vista & 7 are not. It is for my i-cafe software, so i need to disable CTRL+ALT+DEL.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
