Re: Build new Access database from .NET application.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rich Wallace (rich.wallace_at_minusthecannedmeat.jfsheadotcom)
Date: 07/31/04


Date: Fri, 30 Jul 2004 18:49:44 -0700

Thanks guys,

I ended up running a loop on my dataset and performed an INSERT using the
Access.Application.CurrentDB.Execute object and it runs fine. Since the
project is pretty much due befoer I can get fancy with it, this will work
for now, but I'm sure I'll loop around after post-implementation and rethink
it.

-Rich

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:umyFixmdEHA.1764@TK2MSFTNGP10.phx.gbl...
> Paul,
>
> > Since he wants to export from a DataGrid the direct method would not be
> possible.
>
> Why not, I never did it however this should be a one of the possible very
> simple methods
>
> mydataadapter.update(directcast(mydatagrid.datasource, dataset))
>
> Cor
>
>



Relevant Pages

  • Datagrid Add new Row problkem
    ... I think basically your code of second option is OK. ... It should be after datagrid data ... Loop scope. ... > Dim NestedCell As New TableCell ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: DynamicColumnsAccessingRowsDataGrid
    ... Is there away I can check the viewstate in the page load event after I click the submit button? ... Eliyahu Goldin wrote: ... I dynamically create the columns for the datagrid and add them to it. ... In the submit button I loop through the datagrids items and if checked I will save the product to the cart. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DataGrid bug?
    ... You can compare these in a loop to find our that's not the case even though you're not using filtering and sorting. ... Next wrong assumption is what row indexes in the DataGrid would not change while this loop is executed. ... I DataGrid DataView DataTable ... I get the exception only if I select a cell in the rightmost column of the DataGrid before I try to delete some rows. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Datagrid Add new Row problkem
    ... It should be after datagrid ... Loop scope. ... >> Dim NestedCell As New TableCell ... >> Dim dgItem As DataGridItem ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Datagrid Add new Row problkem
    ... I have a datagrid, which creates the columns ... ..begin loop through the rows ... Dim NestedCell As New TableCell ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)