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
|