|
Some comment there confirm my concern:
From article: However, try to find one that does not use the MS Jet driver or perhaps the MS FoxPro driver. I tried myself and couldn't find one
So, I think I will use my own library, that doesn't need to load the entire table into a datatable. Thanks for the link.
Best regards,
Jaime.
|
|
|
|
|
Hi...
I have a value in oracle DB like "3.50324616E-38"..
when I read this value from db in Vc.net using odbcDataReader I get an error like
"Value was too large or small for a decimal"..
The error is encountered in thi line
varname = RdrIns->default::get(row+icnt) ;
i tried many methods of Datareader..like .Getint32, GetInt64 GetDecimal etc..
no use
any help.???
Salai
|
|
|
|
|
led mike
|
|
|
|
|
Yaa I tried....
tried all the methods supported by the OdbcDataReader...
Salai
|
|
|
|
|
It doesn't work because of exactly what the error message says. The smallest value a Decimal type can have is (+/-)1E-28. You're trying the move the decimal point 10 places more to the left than the Decimal type can handle.
|
|
|
|
|
Thanks Dave...
I understud... Is there any other method to handle this data.. The datatype of that column in Oracle is Binary_FLoat. While oracle can store that data why cant .Net access that data??.. I tried with
Rdr->GetData
Rdr->GetDecimal
Rdr->Getint16,32
Rdr->GetDouble
Rdr->GetFloat
etc....
Nothing works...
Salai
|
|
|
|
|
salaikumar wrote: While oracle can store that data why cant .Net access that data??
Was .NET written by Oracle?? No. There's nothing that says Microsoft has to support every feature of every database or anything else that might come .NETs way.
You have to use the Double data type to store the value. It's range is (copied from MSDN documentation):
-1.79769313486231570E+308 through -4.94065645841246544E-324 † for negative values;
4.94065645841246544E-324 through 1.79769313486231570E+308 † for positive values
|
|
|
|
|
Thanks Dave..
When I tried with double, it returns error for other columns..(Since it is a generic function). Atlast I handled this problem by having a try catch with over flow exception and replaced this value with zero to display in reports since this value is very small.. Thanks for your concern to reply.
Salai
|
|
|
|
|
Hi All,
I am learning to use the Unit Testing features in Visual studio team system 2008 for C# projects.The book(Pro Visual studio 2005-Apress) i am reading says to open the "Service Class " to generate the Unit Test.But i cannot seems to know how to do it.
I serached and in am unable to get an answer.Any person out there who havve used Unit testing or made use of any testing tools inbuilt in Visual Studio ;Please provide a hint or any links for the same.
Thanks in advance.
|
|
|
|
|
Hi,
You may take a look at the following links:
Link1[^]
Link2[^]
Link3[^]
Link4[^]
Hope this helps 
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
after clicking Backup option form menubar how can i create backup of my whole project,can i get code for it i m using access as my backend.
|
|
|
|
|
how can i add .Net help to my project .can i get code for it.
|
|
|
|
|
Do you mean - how can I add help to my application, or how can I convert my code-comments into documentation? If it's help, then you will need the Html Help Workshop at the minimum, and possibly a good help authoring tool. If it's code commenting, you might want to look at using SandCastle.
|
|
|
|
|
Please describe your requirement in detail
Cheers!!
Brij
|
|
|
|
|
What is it you are trying to do? Your inquiry makes no sense whatsoever.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I have a a problem that I haven't found found a solution for yet, so I'm turning to you guys.
I need to execute an assembly in a new app domain in order to be able to completely garbage collect all resources that is used. The problem is that I need to return information to the host. How can this be accomplished?
The reason I need to do this is that I'm using the Microsoft.Biztalk.Operations libraries to retrieve messages but (due to what I assume is a bug) sql connections used is not closed until the assembly is unloaded.
Or is there any better way to do this? (GC.Collect does not close the sql connections)
http://msdn.microsoft.com/en-us/library/microsoft.biztalk.operations.aspx[^]
|
|
|
|
|
Don't know about BizTalk, but normally sql connections are pooled so they are not actually closed, but only reset and returned to connection pool.
However, the connection must be closed (in code) before the connection goes out of scope. Without closing the connection properly in .Net you may encounter odd behaviour (especialy with transactions).
After closing the connection in .Net, if you take a look at database server, you can still see the connection (since it's open and in the pool). The connection is actually closed when it ages out of the pool.
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Yeah, I know. The problem is that the connections is never re-used. If I retrieve 1000 biz talk messages, I get 1000 connections, if I wait a couple of seconds and retrieves the messages again, another 1000 connections will be created and this brings down the performance on the entire server. (vital in a production environment)
and there is no way to close or reuse the connections in my code since they are created and used purely within Microsoft's own assemblies.
I've tried to use a appdomain to read messages and this works great. The problem is how to return the data.
|
|
|
|
|
That really sounds horrible!
Since you must have some kind of mechanism to configure the connection string (or at least the elemental parts) could there be some kind of way to disable pooling if it's not used anyway (or even a way to get pooling working).
If you have new connection for each message, the response time will be bad since getting the connection is very slow so this must be either bug or configuration mismatch. I cannot believe it's by design.
If you cannot solve the problem that way, I believe you have following options (since different appdomains cannot share any info directly)
- for example using wcf, create a service which is located in the appdomain that handles db. Define the info you need as out parameters in the service
- communicate directly using IP (using for example loopback address)
- use local db (or even file) to transfer data between domains
- create a windows service that helps to return the data
The need to optimize rises from a bad design
|
|
|
|
|
Check you are disposing stuff that implements IDisposable. A bunch of APIs put IDisposable on relatively innocent looking stuff due to being thin wrappers for COM components (ie: GDI's Matrix class needs to be disposed - and thats really only be six bloody floats).
|
|
|
|
|
Hi!
I have a simple windows form and I want to make this windows form a MMC Snap-In (i.e. when I run the MMC, to be able to open the form in it). How can I do that?
Thanks for the help in advance!
|
|
|
|
|
Welcome to code project ![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif)
If you want to have a good experience here I suggest you take a look around the site and see how things are done. This handy Forum Guidelines article[^] can also be helpful.
In general most people that will try to help you also believe you should be attempting to do the work yourself. This can include the notion that you have attempted to find some information about your subject using Google. In this particular case it was pretty simple, you use the following Google Search
Google Search[^]
and about the seventh link from the top in the search results we find a CodeProject Article on your subject[^]
Good luck
led mike
|
|
|
|
|
|
Nice balanced reply there Mike.
|
|
|
|
|
Pete O'Hanlon wrote: Nice balanced reply there Mike.
Someone must have hacked my account! 
led mike
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
