|
Hi all,
I have a control that builds up queries to be run against both Databases and the .NET DataTable, in this control the user can select individual parts of the query to be case-insensitive. To generate this query for the database is easy because I can just surround the field names and variable with UPPER() e.g.
SELECT * FROM ... WHERE UPPER(name) = UPPER('test') AND surname = 'test' AND town = 'test'
Now I know I can make an entire datatable case-insensitive but I don't want to do this, I want just individual parts of the WHERE clause to be - is there any way of doing this in my DataTable Select()?
Thanks in advance, Tom
|
|
|
|
|
Most databases I know of, are case-insensitive by default.
What is the problem?
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
The .NET DataTable I'm querying on is case sensitive because I've set it to be, what I want a user to be able to do is to add a load of conditions and set just certain ones to be case-insensitive so they may wish to only find a record if the location field matches 'Home' in that case, but also to use the same query to match any records where for example the name field contains 'Test' in any case.
The issue is with .NET DataTables rather than databases because my DB is case-sensitive and to acheive the same result I just wrap UPPER() around the fields I want to make case-insensitive, I hope I've explained this a bit better?
|
|
|
|
|
ro88o wrote: hope I've explained this a bit better?
Yes 
From what I can see, case-sensitivity can only be set on the DataTable as a whole, and not individual columns.
Perhaps, someone else knows of a way?
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
hello i have made setup file for my window application i want to make installation og .net framework by same setup so i am not able to make it plz suggest something
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
Prashant B. Lavate wrote: so i am not able to make it
So what exactly is the problem?
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
i have made setup file added dependencies but when i statrted installation for he shows messgae for frmawork when i click accept it installs it from net
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
You can download .NET framework redistributable and supply it along with your package. The install creator program which I used has an option to install framework before installing application.
|
|
|
|
|
yes but i am making setup file by .net only i.e. set up and deploy and deplymen project so from there how can i make it?
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
And which is that? That sounds like a dandy nice feature, I would definitely like that.
|
|
|
|
|
|
You want to ship .Net framework along with your setup project?
If that is the case, set it as a prerequisite in the properties of your setup project.
Loading signature. Please wait...
|
|
|
|
|
yes i setted that but it asks me url path for that but how can setup the same folder
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
Hello,
I'm using Stream.Read(byte[] buffer, int offset, int count). Is there an alternative to that method (or a property to set) so that the method won't return until all count is read (or end of stream is reached)? Or should I do something like this:
int n = 0, readCount = 0;
while ((n = myStream.Read(buffer, readCount, countToRead - readCount)) > 0)
readCount += n;
|
|
|
|
|
No, you can't force it to read the number of bytes that you request. You have to use a loop with the Read method if you want to read the entire stream.
You should check if the return value from the method is zero, not only if the total number of bytes has reached the expected. If the stream happens to be smaller than you expect, your code will go into an eternal loop.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Yes, I edited the post and checked the return value, probably at the same time you were writing. 
Thanks.
|
|
|
|
|
Hi everybody,
my application (A) opens a port 35000. An external application (B) has the possibility to connect
on this port 35000.
If the application A is launched 3-times it opens the port 35000, for the second the port 35001 and so far...
Now i created a little tool to check which ports are open.
a simple loop which increments the Portnumber from 30000 to 30256.
But it takes 1 second for each port, so more than 256 seconds for all these possible ports...
In the loop i make each time a
new IPEndPoint(...
and
new Socket(....
Does it run faster in asynchronous mode?
Big thanks for help
|
|
|
|
|
baerten wrote: Does it run faster in asynchronous mode?
It should, just fire off each request in it's own thread.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
Thanks for your reply.
But it should also work in a easier way or not?
All Port Scanner Tools works much faster.
I can only test a port each second, thats very slow 
So i open for each port a new thread which executes the work?
Thanks to you
|
|
|
|
|
Yes it should, since each request fires will not wait the previous one to complete, so multi of them will end up in the same time for example, in the addetion, there are two ways now to use asyncrounous calls with sockets now, the old one Begin/End aspect... and the new one which is introduced in .NET Framework 3.5, which is supposed to be faster and holds better performance ideas as well.
Sincerely Samer Abu Rabie
Note: Please remember to rate this post to help others whom reading it.
|
|
|
|
|
How can I change the System partition drive letter using c#.net?
|
|
|
|
|
Even if you could do it in C#, you would have to reboot, and then sh*t will probably hit the fan due to changing the System partition's letter.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
Greetings,
I beleive this could be accomplished using Windows APIs, I havnt seen how its done, but almost anything is exist in Windows APIs, and I this case as well as I think.
Sincerely Samer Abu Rabie
Note: Please remember to rate this post to help others whom reading it.
|
|
|
|
|
I was a big Perl programmer and I am still spoiled with the availability of modules provided by cpan.org. I have looked but have yet to find anything even remotely similar for C# code.
What I am looking for is places to download small classes of different things to save me a bit of time making some prototype programs. As a basic example, it would be nice to download a simple html parser that I could then use or enhance, or maybe a simple ftp class. I can't really think of things off the top of my head but hopefully the provides enough information to address my question. Is their any place to get simple code snipets like this? Sure I can get entire programs but at that rate I'd just prefer writing my own rather then sorting through someone elses whole program.
Tnx.
Trixy
|
|
|
|
|
Yeah, it's called the .net framework. It's so big it includes all the kind of stuff many other languages rely on add on modules for.
There are whole namespaces dedicated to HTTP and FTP stuff. A good place to look for guides and snippets on how to use this stuff is MSDN (although it's often easier to search MSDN from google).
Simon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
