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

[Tim Frawley]

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?

 

[Steven Cheng[MSFT]]

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

 

[Tim Frawley]

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

 

[Steven Cheng[MSFT]]

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