 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / ADO.NET / May 2005Defaults in Column Mappings
Dear All, I have designed a DataAdapter which reads data from a table. The table has an auto-incrementing Primary Key. None of the columns in the table accept Nulls although some of the columns do have defaults. My question is - Is there an automatic method of filling these properties on the table when I call the fill method, or do I have to manually key the properties for each column when the table has been filled? Thanks in advance for your assistance Mike Mike, You mean this one http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr fsystemdatadatacolumnclassdefaultvaluetopic.asp I hope this helps, Cor Thanks for this Cor, but what I want is for the adapter (or some other object) to read the default information from the database schema and populate the default property in the datatable's datacolumn. Does this make sense? > Mike, > [quoted text clipped - 4 lines] > > Cor Mike, > Does this make sense? Yes however that is not done. I have seen many flaming messages to Microsoft about this how stupid they are not to implement this. However don't forget that AdoNet connects to all kind of databases. It should be an SQL function to get this from the schema. It does not help you, however now you know. Cor Sorry, just to be more specific - it is the column defaults which I want to be populated. Thanks Mike > Dear All, > [quoted text clipped - 9 lines] > > Mike 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.