Re: Newbee Question - Updating Data With a DataGridView

Tech-Archive recommends: Fix windows errors by optimizing your registry

The code for it should be in your project. If you see an XSD file for your
DataSet, expand it and look at the Designer for it, or use the Class View to
examine the class structures.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

"Greg P" <gsp@xxxxxxxxxxxxxxxxx> wrote in message
news:EBDB3335-3098-405F-A536-A91EAF7721EA@xxxxxxxxxxxxxxxx
Thanks for the time, I guess the question is where is the dataAdaptor that
the wizard creates? How do I access the update capabilities? I see a
tableAdaptor that is created, is that what I'm looking for? If not what
is
the name of my dataAdaptor and where does it live?

Thanks
Greg

"Kevin Spencer" wrote:

Well, you can't expect Visual Studio to do everything for you, simply
because there are so many possible combinations of things programmers
want
to do. It provides some excellent tools that will save you a lot of time,
but at some point you have to know what it is that it is doing for you,
and
be able to work with it.

Basically, here's a clue for you. When you did that dragging and
dropping,
Visual Studio was busily writing code that defines a number of classes,
including strongly-typed DataSets, DataTables, and DataAdapters. It is a
DataAdapter that provides the link between the DataSet and the underlying
Data Store (in this case a database). And even though Visual Studio
didn't
need to include code to update the database, delete or insert new
records,
into it, in order to populate your DataSet for you, it did write that
functionality in there. Microsoft anticipated that you might want to do
something like that.

So, you just need to look at the classes that were developed for you,
find
the functionality you need, and use it.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

"Greg P" <gsp@xxxxxxxxxxxxxxxxx> wrote in message
news:64D0EF54-F2A3-49D3-BFE7-1A9519312599@xxxxxxxxxxxxxxxx
I just wanted to make sure I was clear, this link shows you how to do
this
programmatically:

http://msdn2.microsoft.com/en-us/library/fbk67b6z(VS.80).aspx

Yet I want to use the visual capability of VS and not set every
parameter
myself. This seems so much more complicated than in VB6 where you set
the
updatable property of the datagrid!!! Why is this such a pain to do?

"Greg P" wrote:

I'm new to VS2005 and want to simply update my data with the
dataGridView
that was generated when I draged my query from the Data Sources Pane.
I
think I may need to create a Data Adaptor but I'm not sure? The other
think
I saw was to implement IEditable? How would I do that? Where in my
code
woudl I do that considering I am not creating the DataGridView via
code?

I know this is probably the easist thing to do I just don't know how?

Thanks in advance,







.

Relevant Pages

  • Visual Studio 2005 Thoughts
    ... Add a GroupBox to your form, then add a dataGridView. ... Groupbox font to something and then, thank you very much, Microsoft ... Do the Visual Studio developers ever talk with Visual Foxpro ... You can only hope that the project/solution opens ...
    (microsoft.public.vstudio.general)
  • Re: VS 2005 all but stopped working EXTREEMLY slow
    ... This is not a Visual Studio issue. ... what went wrong when the crash occurred and fix it, ... Hard work is a medication for which ... placeholder controls. ...
    (microsoft.public.vsnet.general)
  • RE: Linefeed in Datacolumn.Expression
    ... I assume you are using Visual Studio 2005, ... the typed dataset in design mode will automatically convert ... by DataGridView. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Refresh DataGridView with Latest Data
    ... Professional Numbskull ... Hard work is a medication for which ... What can I do to refresh the datagridview? ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: Generated code for DataGridView and Update
    ... I have a DataGridView that displays data from one table from database. ... Visual Studio generated strong typed dataset and binding. ... tblMyTableBindingSource.DataSource = dataSetLKS; ...
    (microsoft.public.dotnet.languages.csharp)