 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / ADO.NET / June 2004Identity and primary keys
I'm looping thru all the columns in a dataset that was filled from a SQL Server table. I want to be able to exclude the columns that have an identity key or are primary keys in SQL Server. Is there any method or property for this in the dataset? or how do you go about getting that information for each column? Thanks You can query the master database tables to figure out which are keys, but there is nothing you can do in ADO.NET or your .NET code to automagically remove primary keys and identity fields.  SignatureGregory A. Beamer MVP; MCP: +I, SE, SD, DBA ************************************************ Think Outside the Box! ************************************************ > I'm looping thru all the columns in a dataset that was filled from a SQL > Server table. I want to be able to exclude the columns that have an identity [quoted text clipped - 3 lines] > > Thanks Why are you including them in the query then? If you are pulling the stuff over just to remove it, it's a waste every way around. SignatureW.G. Ryan, eMVP http://forums.devbuzz.com/ http://www.knowdotnet.com/williamryan.html http://www.msmvps.com/WilliamRyan/ > I'm looping thru all the columns in a dataset that was filled from a SQL > Server table. I want to be able to exclude the columns that have an identity [quoted text clipped - 3 lines] > > Thanks It was just as an example, I just need to know extra information about each column as compared to the field in the table. > Why are you including them in the query then? If you are pulling the stuff > over just to remove it, it's a waste every way around. [quoted text clipped - 14 lines] > > > > Thanks Cool, but what do you want to delete it for? Are you including it just so you can get that information? You can get that info from Information_Schema.Columns if you're using Sqlserver SignatureW.G. Ryan, eMVP http://forums.devbuzz.com/ http://www.knowdotnet.com/williamryan.html http://www.msmvps.com/WilliamRyan/ > It was just as an example, I just need to know extra information about each > column as compared to the field in the table. [quoted text clipped - 19 lines] > > > > > > Thanks Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.