Click here to Skip to main content
15,898,010 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to use a field in database, that should not be present in C# windows form application?
Posted
Updated 24-Dec-10 1:19am
v3

1 solution

If you don't want the content of a database column to appear in the GUI of your application then you either just don't display it or you formulate your SQL select statement so the column you don't want to appear is not selected.

SQL
SELECT column1, column2, column4, column6
FROM myTable
WHERE ...


Suppose you had a table myTable with columns named column1 through column6.
With the select statement above you'd omit column3 and column5.

That should help!


Cheers,


Manfred
 
Share this answer
 
v4
Comments
fjdiewornncalwe 24-Dec-10 11:47am    
How in the name of all the gods ever thought up did you figure out what this guy wanted from that. I sit in awe before you, Manfred...
Manfred Rudolf Bihy 24-Dec-10 11:55am    
That's just my take on what he wrote. I may be off by a mile, but here on CP you sometimes get more than you asked for. :)
Or even something completely different.
Happy Xmas, solstice, <insert prefered="" reason="" to="" celebrate=""> Marcus!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900