|
I use 2 methods
limit the columns selected from the database, this gets rid of useless columns
set the column. visible = false - this hides the columns that are required but do not need to be seen by the user (id column)
You can still access the data in a non visible column
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello,
I'm trying to retrieve the columns from an Oracle 9i database using OdbcConnection class's getSchema method. While I can retrieve the tables and views just fine with getSchema("tables"), everytime I call getSchema("columns") I get a System.FormatException with message "Input string was not in a correct format".
I've tried various combinations of the schema string, such as "Columns", "COLUMNS", etc.
Thanks in advance.
Reference: http://msdn.microsoft.com/en-us/library/cc668760.aspx[^]
|
|
|
|
|
The GetSchema functionality depends on the ODBC driver. Are you using Microsoft's Oracle ODBC driver and if not, could you test GetSchema using that driver?
|
|
|
|
|
I was unable to configure Microsoft's ODBC Oracle driver successfully with the database, so I'm using Oracle's 9i driver. Thanks for the reply.
|
|
|
|
|
|
Mika,
Thanks for your suggestion about the driver; getSchema("columns") works fine with the Oracle database after I configure the connection using Microsoft's Oracle driver instead of Oracle's 9i driver.
There is one concern, though--will the future versions of Oracle database continue to work with Microsoft's driver?
Lastly, I'm still curious as to why getSchema("Tables") works with Oracle's driver but not getSchema("Columns").
Thanks.
|
|
|
|
|
Sorry for the late answer!
stilz wrote: will the future versions of Oracle database continue to work with Microsoft's driver?
Usually the will for a version or two. But if you upgrade the Microsofts driver when a newer Oracle version comes out, it usually supports new features better. However there's no quarantee for this, but that has been the situation for more thatn 10 years.
stilz wrote: Lastly, I'm still curious as to why getSchema("Tables") works with Oracle's driver but not getSchema
I would guess that Oracle simply hasn't implemented that. I think their main priority is to get people to use native connections, either System.Data.Oracle.OracleConnection (Microsoft's version) or Oracle.DataAccess.OracleConnection (Oracle's version).
|
|
|
|
|
How can i hide tooltip on properties when they are displayed through propertygrid.
Thanks
|
|
|
|
|
Hi everyone!
I'm working on a project and i need to do what follows:
i have an array of strings,example:
house3
house2
green23
green.5
H6
H01
G19
G78
..and so on.
I have to extract only the recurrent strings: house,green,H,G.
Any idea about it? (the language is java but doesn't matter, i just need the idea!)
Thanks in advance,
Enrico.
Program your life ^^
|
|
|
|
|
Lots of them but this looks like homework.
I imagine the Vector class is somewhere in your near future and use of the contains method.
Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.
|
|
|
|
|
Hi,
this would be my attempt:
- strip all redundant characters from each string, probably every non-letter;
- optionally: normalize the casing, say convert all strings to lower-case;
- collect the strings in a List<string>, however before adding them, check whether the new string
is already present; if so you found a duplicate.
(you can improve on this by using a Dictionary which holds the string as a key, and the occurence
count as an int value).
BTW: why ask for an algorithm in a language oriented forum that does not match your language?
we do have a "Math and algorithms" forum.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
modified on Friday, June 10, 2011 11:38 PM
|
|
|
|
|
Luc Pattyn wrote: BTW: why ask for an algorithm in a language oriented forum that does not match your language?
we do have a "Math and algorithms" forum.
Is not the forum called "Algorithms", I don't see "Math" there?
|
|
|
|
|
Ravadre wrote: Is not the forum called "Algorithms",
it has been called "Algorithms and Math", as well as "Math and algorithms" before.
However you are right, this week it is called "Algorithms". 
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
modified on Friday, June 10, 2011 11:38 PM
|
|
|
|
|
try using regular expressions....using remove method.. removing pattern[0-9]
the quieter u become more u hear
|
|
|
|
|
great idea lawrenceinba! but what do you mean with "removing the pattern"?
i'm not sure to understand this way..
Program your life ^^
|
|
|
|
|
Hi,
I am a developing an webcrawler in c#. The crawler will take a url from the user and crawls through the page pointed by that url fetching the urls it can find from the page.This is a recurring activity and the output is a huge collection of strings/urls.
Please tell me which is the best holder for such a huge data. I considered access database but it makes the application slow since reading and writing is a frequent activity.
Thanks,
John.
|
|
|
|
|
you could try a StreamWriter straight to a file
If only MySelf.Visible was more than just a getter...
|
|
|
|
|
Well, I'm about to pull my hair out on this. So I figured I'd post for help before I cause some premature baldness.
I'm fairly new to C# and have run into this problem trying to get info out of a int byte that I get returned.
Here is what is stated in the lib that I'm working with:
The first three bits represent a single value, not flags.
For example Auction (0x05) is not a combination of OwnedByOther (0x01) and ForSale(0x04). However, the BorderWest and BorderSouth values are bit flags that get attached to the value stored in the first three bits. Bits four, five, and six are unused.
public enum OverlayType : byte
{ Public = 0,
OwnedByOther = 1,
OwnedByGroup = 2,
OwnedBySelf = 3,
ForSale = 4,
Auction = 5,
BorderWest = 64,
BorderSouth = 128
}
So where I'm lost is trying to get the first 3 bits out and get the enum OverlayType from them. Plus the BoarderWest & BorderSouth.
|
|
|
|
|
Im a bit confused as to what you are trying to do?
If only MySelf.Visible was more than just a getter...
|
|
|
|
|
mask them
byte someByte ...;
byte masked = (someByte & 0xE) >> 2;
Don't trust my math on the bit shift though I was just guessing.
Need custom software developed? I do C# development and consulting all over the United States.
If you don't ask questions the answers won't stand in your way.
Doing a job is like selecting a mule, you can't choose just the front half xor the back half so when you ask me to do a job don't expect me to do it half-assed.
|
|
|
|
|
Hello,
You would split your byte before checking for flags (borders) or values (<=5).
OverlayType value = (OverlayType)(type & 0x7); <br />
OverlayType flags = (OverlayType)(type & 0xC0);<br />
Or just do mask bits every time you need to check values from your byte. When checking for flags you don't care about lesser 3 bits, when checking for values, you just need to mask higher bits.
I'm not sure if I understand you well though, so I don't know if this is going to be any help.
|
|
|
|
|
ok, thanks. That's starting to make a bit of sence.
What I'm trying to do is check if it is Forsale and if so what are the BorderWest & BorderSouth.
the BorderWest & BorderSouth should each be a number. I got this working to identify what type it is. But now how do I get those boarder numbers?
modified on Tuesday, February 10, 2009 1:54 PM
|
|
|
|
|
the BorderWest & BorderSouth should each be a number. I got this working to identify what type it is. But now how do I get those boarder numbers?
In your example Borders are bit flags, so what do you mean by "border numbers"? They don't have a number, they are set or no.
|
|
|
|
|
hhmm, somewhere in there is a set of coordanants for the item. To locate it.
The summary part of that is:
"However, the BorderWest and BorderSouth values are bit flags that get attached to the value stored in the first three bits. Bits four, five, and six are unused"
That's what has been really confusing me. Trying to find those.
How can I just print out all the values in original int byte. Maybe just seeing whats in there I can locate the coords.
Thanks again for all your help.
|
|
|
|
|
Hello,
You are giving incomplete information or I can't understand your point.
You have a byte, that is what you have said. It has 2 bit flags (borderw, borders), which are set or not and some sort values, which I'm not sure what they do. Now your asking about getting sets of coordinates, without saying what they really are and from where you would like to get them. I'm confused .
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
