Re: DataSet

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

From: Rodrigo (rborges11_at_hotmail.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 14:23:41 -0300

Dears Paul and Wilian,

I think the DataGrid is not gonna work very well for me, because there are a
lot of tables to fill. I have a big form and some master \ details on it.
I don't have experience with C# and I've tryed to understand these objects
and the best way to use them.
After you sent me the examples, I could make good changes in my code. Now I
can fill a DataSet and bind controls with the data.

Now, I have problems to change the data.
I´ve set the UpdateCommand() and I'm using the EndEdit() and AcceptChanges()
but I can't apply the changes to the database.

The is no error messages, but the changes doesn't apply on the db.

Thanks for your help.

Rodrigo.

"Paul G. Tobey [eMVP]" <ptobey_no_spam@instrument_no_spam.com> wrote in
message news:%23YDp%234ZTEHA.3336@TK2MSFTNGP10.phx.gbl...
> I'm pretty sure I don't understand the question. If you are asking, how
> should you display tabular data, I'd say a DataSet and a DataGrid, as my
> query sample code did. If this application has only one job: populating
the
> database, then you can ask the user questions or whatever you want to get
> the data values...
>
> Paul T.
>
> "Rodrigo" <rborges11@hotmail.com> wrote in message
> news:OKqU%23gZTEHA.1988@TK2MSFTNGP12.phx.gbl...
> > Thanks Paul for your help.
> >
> > I have more questions.
> >
> > I've created a database using sql server CE in a MS Pocket PC device.
> > My database has a lot of tables and I have to make an app that provide
> user
> > to fill it offline.
> >
> > The user has to choose the customer in a combobox and then the system
show
> > all the data in some objects like textbox and combox, etc. But, the data
> has
> > come by a lot of tables and the user has to change it.
> >
> > How is the best way to do this?
> >
> > Using DataSet?
> > Using SQLCEDataAdapter?
> > Using SQLCEDataReader?
> >
> > Thanks for any help.
> >
> >
>
>

Relevant Pages

  • Re: DataSet
    ... should you display tabular data, I'd say a DataSet and a DataGrid, as my ... > Thanks Paul for your help. ... > I've created a database using sql server CE in a MS Pocket PC device. ... > Using SQLCEDataAdapter? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Adding rows to DataGrid across multiple PostBacks
    ... (not adding to the database or whatever you want to perform ... is only after adding information for every Id Number to the datagrid.) ... datasource which can contain a collection of datatables. ... The user can then put in a new IDNumber, ...
    (microsoft.public.dotnet.framework.aspnet)
  • DataGrid and Selected Rows
    ... In the form I instantiate a DataTable object. ... I have a DataGrid on the form which is bound to the *second* ... How can I iterate through the rows of the grid and see which ones are ... Keep in mind that the DataGrid is not bound to the Access database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: show collapsible datagrid headers
    ... I get a bunch of fields showing my expenses,for example, from the database. ... it should expand to show me columns for CarInsurance and HomeInsurance.Then i ... So i might have to create DIV tags and associate them with the datagrid ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: moving record in datagrid
    ... the results from your database ... can be determined by sort order. ... Obviously the "rows" in a datagrid have to be ordered by one of the fields. ... priority" field where the user assigns the priority of the record in the ...
    (microsoft.public.dotnet.framework.windowsforms.controls)