Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 2nd, 2004, 01:19 AM
Registered User
 
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Saving a dataset to an Access table

Hi guys, i need your help on this. please!

in my access database there is a table called Bills and in that table its got a column called 'datSet' . the data type of this column is OLE Object.
i am adding a DataSet to this column and the problem is when i retrieve the records this particular column's data type is System.Byte i want this type in System.DataSet. how can i do that?
the code is:
(code is written in C#)

String sql = "INSERT INTO Bills(billerDate ,datSet VALUES('"+currentDate+ "','"+dataSet+"')";

the way i retrieve it is

DataSet d = srchDataSet.Tables["Bills"].Rows[0]["datSet"];
is there a way i can cast this System.Byte type to a System.DataSet

any help would be appriciated please.
smego

        





Similar Threads
Thread Thread Starter Forum Replies Last Post
saving a dataset into access db igalk474 ADO.NET 3 July 21st, 2007 05:28 AM
saving informations to table sarah lee ASP.NET 1.0 and 1.1 Basics 6 December 12th, 2006 03:00 PM
Saving DataSet data on client machine in .csv file balesh ASP.NET 1.0 and 1.1 Professional 0 October 25th, 2006 06:17 AM
Dataset merging and saving to database Talarin3 ADO.NET 8 April 19th, 2006 11:30 AM
Re: SQL Server dataset to ACCESS dataset dazzer ADO.NET 0 March 22nd, 2004 05:28 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.