PC Review


Reply
Thread Tools Rate Thread

Default values in Access database not applied to Dataset datarow...

 
 
Tim Frawley
Guest
Posts: n/a
 
      27th Feb 2004
I have a situtation where I am adding a Row to a Dataset that was
filled with an Access table. The column in the Access table shows a
default value of 0 (zero) but when I create a new row on the dataset
the values in the datarow are null for all columns.

Is there a way to default all columns in the dataset or datarow to 0
so that I will not have to loop through the columns and set the value
to 0?
 
Reply With Quote
 
 
 
 
Steven Cheng[MSFT]
Guest
Posts: n/a
 
      2nd Mar 2004
Hi Tim,

Have you had a chance to try out my suggestion or have you resolved the
problem. If you need any further help, please feel free to post here.


Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

 
Reply With Quote
 
Tim Frawley
Guest
Posts: n/a
 
      2nd Mar 2004


Steven,

Sorry I didn't respond sooner. I tried this out and it worked
beautifully. It also shaved 90 seconds off of the time necessary to
import 200 rows of biological data from a text file.

Many thanks!


Tim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
Steven Cheng[MSFT]
Guest
Posts: n/a
 
      3rd Mar 2004
Hi Tim,

Thanks for your followup. I'm very glad my suggestion has helped you
resolve the problem.


Best Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default values when adding new datarow =?Utf-8?B?R3VkbmkgRy4gU2lndXJkc3Nvbg==?= Microsoft Dot NET Framework Forms 0 27th Nov 2006 04:37 PM
Dataset doesn't return true when dataset datarow has been modified =?Utf-8?B?QWxwaGE=?= Microsoft C# .NET 3 11th Nov 2005 09:16 PM
Generate Dataset does not carry over Default Values from Database TommyS Microsoft ADO .NET 1 9th Mar 2004 05:18 PM
why doesn't dataset generator use default values defined in the database? boo Microsoft ADO .NET 1 13th Nov 2003 07:58 PM
Re: Append a datarow to an Access Database using VB.NET Michael Lang Microsoft ADO .NET 0 7th Aug 2003 06:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:47 AM.