create a new column byusing VB.net and ADO.net

  • Thread starter Thread starter Venkateswara Kumar Kasaram via .NET 247
  • Start date Start date
V

Venkateswara Kumar Kasaram via .NET 247

Hi,
I am working with excel as a database.first i am getting thedatafrom excel and creating dataset and later i am working withdataset,where i am creating new column in to thedataset.Finnalyi want to update the excel sheet with the datasetvalues.But i am not able to create a new columns which arecreated in dataset in to excel.

Simply:

i need to create a new column byusing VB.net and ADO.net

Kindly please help me on this
Thanks in advance
 
Hi,

When you create DataColumn in a datatable, it does not mean it will be
automatically created in a database (Excel or other). First you need to
create this column separately in a Excel itself and then you could populate
it from the DataSet. You could create column in Excel using ADOX COM library
through COM Interop. See next KB with some info about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303814

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



message Hi,
I am working with excel as a database.first i am getting the datafrom
excel and creating dataset and later i am working with dataset,where i am
creating new column in to the dataset.Finnalyi want to update the excel
sheet with the dataset values.But i am not able to create a new columns
which are created in dataset in to excel.

Simply:

i need to create a new column byusing VB.net and ADO.net

Kindly please help me on this
Thanks in advance
 
Back
Top