|
List Info
Thread: Update data in a DataGrid
|
|
| Update data in a DataGrid |
  United States |
2007-10-03 23:19:07 |
Hi all, I have a VB.Net 2005 application that I am working
on that I
could use some help with.
I have a form thats loads values from an access database and
displays
them in a DataGrid.
It loads them without any problems, however, if I want to
update any
of the values it crashes and gives me error message -
OleDbException
was Unhandled - No value Given for one or more required
parameters.
Im puzzled as the update code is actually generated by the
VB IDE
itself and not me. Nor have I modified it in any way.
I have listed the code below. Any help would be GREATLY
appreciated.
************************************************************
*******************************
Public Class Form1
Private Sub
RoundDetailsBindingNavigatorSaveItem_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs)
Handles
RoundDetailsBindingNavigatorSaveItem.Click
Me.Validate()
Me.RoundDetailsBindingSource.EndEdit()
Me.RoundDetailsTableAdapter.Update(Me.RoundInfoDataSet.Round
Details)
- {Error message points to here}
End Sub
Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As
System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'RoundInfoDataSet.RoundDetails' table. You can move, or
remove it, as
needed.
Me.RoundDetailsTableAdapter.Fill(Me.RoundInfoDataSet.RoundDe
tails)
************************************************************
*******************************************
Thanks all
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |
  United States |
2007-10-17 23:38:46 |
In answer to my own question...............
The code itself is actually perfectly correct (given that it
was
created by VB's wizards it should be).
However, somewhere along the way I had removed the Primary
Key
indicator on my MS Access Database.
So despite my NUMEROUS attempts save data it would come back
with one
form of error or another. Each and every one of them
disappeared when
I added the Primary Key.
SOOOOOOOOOO SIMPLE YET SOOOOOOOOOOO FRUSTRATING!!!!!!!!!!!
On Oct 4, 2:19 pm, Bails <andrewgbail... gmail.com> wrote:
> Hi all, I have a VB.Net 2005 application that I am
working on that I
> could use some help with.
>
> I have a form thats loads values from an access
database and displays
> them in a DataGrid.
>
> It loads them without any problems, however, if I want
to update any
> of the values it crashes and gives me error message -
OleDbException
> was Unhandled - No value Given for one or more required
parameters.
>
> Im puzzled as the update code is actually generated by
the VB IDE
> itself and not me. Nor have I modified it in any way.
>
> I have listed the code below. Any help would be GREATLY
appreciated.
>
>
************************************************************
*******************************
> Public Class Form1
>
> Private Sub
RoundDetailsBindingNavigatorSaveItem_Click(ByVal
> sender As System.Object, ByVal e As System.EventArgs)
Handles
> RoundDetailsBindingNavigatorSaveItem.Click
> Me.Validate()
> Me.RoundDetailsBindingSource.EndEdit()
>
>
Me.RoundDetailsTableAdapter.Update(Me.RoundInfoDataSet.Round
Details)
> - {Error message points to here}
>
> End Sub
>
> Private Sub Form1_Load(ByVal sender As
System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Load
> 'TODO: This line of code loads data into the
> 'RoundInfoDataSet.RoundDetails' table. You can move, or
remove it, as
> needed.
>
>
Me.RoundDetailsTableAdapter.Fill(Me.RoundInfoDataSet.RoundDe
tails)
>
>
************************************************************
*******************************************
>
> Thanks all
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |
  United States |
2007-10-18 07:51:05 |
Isn't the debugger a wonderful thing?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |

|
2007-10-18 07:52:38 |
What is this debugger you speak of? I normally just post
here when I
have a bug in my code :/
On 18/10/2007, cleveridea <cleveridea.net gmail.com> wrote:
>
> Isn't the debugger a wonderful thing?
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |
  United States |
2007-10-18 10:15:50 |
Yup, posting here and waiting for responses is easier than
pressing
the F5 key... :P
On Oct 18, 5:52 pm, "Jamie Fraser"
<jamie.fra... gmail.com> wrote:
> What is this debugger you speak of? I normally just
post here when I
> have a bug in my code :/
>
> On 18/10/2007, cleveridea <cleveridea.... gmail.com> wrote:
>
> > Isn't the debugger a wonderful thing
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |

|
2007-10-18 19:32:55 |
|
F5? What is this F5?
Personally I like to right-click my solution to build ... none of this silly shortcut key crap ... explicitness and transparency in all things!
On 10/18/07,
Cerebrus < zorg007 sify.com">zorg007 sify.com> wrote:
Yup, posting here and waiting for responses is easier than pressing the F5 key... :P
On Oct 18, 5:52 pm, "Jamie Fraser" < jamie.fra... gmail.com">jamie.fra... gmail.com> wrote:
> What is this debugger you speak of? I normally just post here when I > have a bug in my code :/ > > On 18/10/2007, cleveridea < cleveridea.... gmail.com">cleveridea.... gmail.com
> wrote: > > > Isn't the debugger a wonderful thing
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
|
| Re: Update data in a DataGrid |
  United States |
2007-10-18 20:34:14 |
It would be nice if the debuggar would explain things in
plain
language.
It was an absolute fluke that I found the answer to my
problem,
nothing to do with the debuggar (other than it stopped my
app EVERY
time).
On Oct 19, 10:32 am, "Andrew Badera"
<and... badera.us> wrote:
> F5? What is this F5?
>
> Personally I like to right-click my solution to build
... none of this silly
> shortcut key crap ... explicitness and transparency in
all things!
>
> On 10/18/07, Cerebrus <zorg... sify.com> wrote:
>
>
>
>
>
> > Yup, posting here and waiting for responses is
easier than pressing
> > the F5 key... :P
>
> > On Oct 18, 5:52 pm, "Jamie Fraser"
<jamie.fra... gmail.com> wrote:
> > > What is this debugger you speak of? I
normally just post here when I
> > > have a bug in my code :/
>
> > > On 18/10/2007, cleveridea
<cleveridea.... gmail.com> wrote:
>
> > > > Isn't the debugger a wonderful thing-
Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |

|
2007-10-18 20:37:30 |
|
The debugger really does, typically, explain things as plainly as possible. However, there IS a TON of context to grok before all debugger messages make sense. I can attest to several gurus I've worked with being completely puzzled by debugger info, sometimes for days or weeks on end.
In this case, however, I think it was just a matter, to be honest, of you exploring the issue further. The message, or message of the inner exception, typically gives pretty specific detail.
--ab
On 10/18/07, Bails < andrewgbaillie gmail.com">andrewgbaillie gmail.com> wrote:
It would be nice if the debuggar would explain things in plain language.
It was an absolute fluke that I found the answer to my problem, nothing to do with the debuggar (other than it stopped my app EVERY
time).
On Oct 19, 10:32 am, "Andrew Badera" < and... badera.us">and... badera.us> wrote: > F5? What is this F5? > > Personally I like to right-click my solution to build ... none of this silly
> shortcut key crap ... explicitness and transparency in all things! > > On 10/18/07, Cerebrus < zorg... sify.com">zorg... sify.com> wrote: > > > > >
> > Yup, posting here and waiting for responses is easier than pressing > > the F5 key... :P > > > On Oct 18, 5:52 pm, "Jamie Fraser" < jamie.fra... gmail.com">
jamie.fra... gmail.com> wrote: > > > What is this debugger you speak of? I normally just post here when I > > > have a bug in my code :/ > > > > On 18/10/2007, cleveridea <
cleveridea.... gmail.com">cleveridea.... gmail.com> wrote: > > > > > Isn't the debugger a wonderful thing- Hide quoted text - > > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
|
| Re: Update data in a DataGrid |
  United States |
2007-10-18 23:59:04 |
Your probably right Andrew, though I now have another
example of the
debugger being a bugga and spitting out gobledegook.
I have listed it below.
If you can make any sense of it I'd be greatful.
All I can make out from the following error is that i dont
have
"referenced assembly installed" on my machine -
but which reference??
************************************************************
***************************
PLATFORM VERSION INFO
Windows : 5.1.2600.131072
(Win32NT)
Common Language Runtime : 2.0.50727.1378
System.Deployment.dll : 2.0.50727.1378
(REDBITSB2.050727-1300)
mscorwks.dll : 2.0.50727.1378
(REDBITSB2.050727-1300)
dfdll.dll : 2.0.50727.1378
(REDBITSB2.050727-1300)
dfshim.dll : 2.0.50727.1378
(REDBITSB2.050727-1300)
SOURCES
Deployment url :
file:///C:/Documents%20and%20Settings/fabian/My%20Documents/
Visual%20Studio%202005/Projects/Holdem%20Tournament%20Timer
/Published/Holdem%20Tournament%20Timer.application
Application url :
file:///C:/Documents%20and%20Settings/fabian/My%20Documents/
Visual%20Studio%202005/Projects/Holdem%20Tournament%20Timer
/Published/Holdem%20Tournament%20Timer_1_0_1_13/Holdem%20To
urnament%20Timer.exe.manifest
IDENTITIES
Deployment Identity : Holdem Tournament
Timer.application,
Version=1.0.1.13, Culture=en-AU,
PublicKeyToken=a675fef2688dba94,
processorArchitecture=msil
Application Identity : Holdem Tournament
Timer.exe,
Version=1.0.1.13, Culture=en-AU,
PublicKeyToken=a675fef2688dba94,
processorArchitecture=msil, type=win32
APPLICATION SUMMARY
* Installable application.
ERROR SUMMARY
Below is a summary of the errors, details of these
errors are
listed
later in the log.
* Activation of C:Documents and SettingsfabianMy
Documents
Visual
Studio 2005ProjectsHoldem Tournament
TimerPublishedHoldem
Tournament Timer.application resulted in exception.
Following failure
messages were detected:
+ The referenced assembly is not installed
on your
system.
(Exception from HRESULT: 0x800736B3)
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [19/10/2007 10:04:09 AM] : Activation of
C:Documents and
Settings
fabianMy DocumentsVisual Studio 2005ProjectsHoldem
Tournament
TimerPublishedHoldem Tournament Timer.application has
started.
* [19/10/2007 10:04:27 AM] : Processing of
deployment manifest
has
successfully completed.
* [19/10/2007 10:04:27 AM] : Installation of the
application
has
started.
* [19/10/2007 10:04:27 AM] : Processing of
application
manifest has
successfully completed.
* [19/10/2007 10:04:49 AM] : Request of trust and
detection
of
platform is complete.
* [19/10/2007 10:04:50 AM] : Downloading of
subscription
dependencies
is complete.
* [19/10/2007 10:04:50 AM] : Commit of the
downloaded
application has
started.
ERROR DETAILS
Following errors were detected during this
operation.
* [19/10/2007 10:04:50 AM]
System.Runtime.InteropServices.COMException
- The referenced assembly is not installed
on your
system.
(Exception from HRESULT: 0x800736B3)
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Internal.Isolation.IStore.GetAssemblyInfor
mation(UInt32
Flags, IDefinitionIdentity DefinitionIdentity, Guid&
riid)
at
System.Deployment.Internal.Isolation.Store.GetAssemblyManife
st(UInt32
Flags, IDefinitionIdentity DefinitionIdentity)
at
System.Deployment.Application.ComponentStore.GetSubscription
StateInternal(D
efinitionIdentity
subId)
at
System.Deployment.Application.SubscriptionStore.GetSubscript
ionStateInterna
l(SubscriptionState
subState)
at
System.Deployment.Application.ComponentStore.CollectCrossGro
upApplications(
Uri
codebaseUri, DefinitionIdentity deploymentIdentity,
Boolean&
identityGroupFound, Boolean& locationGroupFound,
String&
identityGroupProductName)
at
System.Deployment.Application.SubscriptionStore.CommitApplic
ation(Subscript
ionState&
subState, CommitApplicationParams commitParams)
at
System.Deployment.Application.ApplicationActivator.InstallAp
plication(Subsc
riptionState&
subState, ActivationDescription actDesc)
at
System.Deployment.Application.ApplicationActivator.PerformDe
ploymentActivat
ion(Uri
activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateD
eploymentWorker
(Object
state)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
On Oct 19, 11:37 am, "Andrew Badera"
<and... badera.us> wrote:
> The debugger really does, typically, explain things as
plainly as possible.
> However, there IS a TON of context to grok before all
debugger messages make
> sense. I can attest to several gurus I've worked with
being completely
> puzzled by debugger info, sometimes for days or weeks
on end.
>
> In this case, however, I think it was just a matter, to
be honest, of you
> exploring the issue further. The message, or message of
the inner exception,
> typically gives pretty specific detail.
>
> --ab
>
> On 10/18/07, Bails <andrewgbail... gmail.com> wrote:
>
>
>
>
>
> > It would be nice if the debuggar would explain
things in plain
> > language.
>
> > It was an absolute fluke that I found the answer
to my problem,
> > nothing to do with the debuggar (other than it
stopped my app EVERY
> > time).
>
> > On Oct 19, 10:32 am, "Andrew Badera"
<and... badera.us> wrote:
> > > F5? What is this F5?
>
> > > Personally I like to right-click my solution
to build ... none of this
> > silly
> > > shortcut key crap ... explicitness and
transparency in all things!
>
> > > On 10/18/07, Cerebrus <zorg... sify.com> wrote:
>
> > > > Yup, posting here and waiting for
responses is easier than pressing
> > > > the F5 key... :P
>
> > > > On Oct 18, 5:52 pm, "Jamie
Fraser" <jamie.fra... gmail.com> wrote:
> > > > > What is this debugger you speak of?
I normally just post here when I
> > > > > have a bug in my code :/
>
> > > > > On 18/10/2007, cleveridea
<cleveridea.... gmail.com> wrote:
>
> > > > > > Isn't the debugger a wonderful
thing- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |

|
2007-10-19 02:53:42 |
Thats the browser-refresh shortcut, so once you've posted
here you can
frantically hit F5 until you get a full solution!!!!
On 19/10/2007, Andrew Badera <andrew badera.us> wrote:
> F5? What is this F5?
>
> Personally I like to right-click my solution to build
... none of this silly
> shortcut key crap ... explicitness and transparency in
all things!
>
>
>
>
> On 10/18/07, Cerebrus <zorg007 sify.com> wrote:
> >
> > Yup, posting here and waiting for responses is
easier than pressing
> > the F5 key... :P
> >
> > On Oct 18, 5:52 pm, "Jamie Fraser"
<jamie.fra... gmail.com> wrote:
> > > What is this debugger you speak of? I
normally just post here when I
> > > have a bug in my code :/
> > >
> > > On 18/10/2007, cleveridea
<cleveridea.... gmail.com > wrote:
> > >
> > > > Isn't the debugger a wonderful thing
> >
> >
> > > >
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "DotNetDevelopment, VB.NET, C# .NET,
ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting"
group.
To post to this group, send email to DotNetDevelopment googlegroups.com
To unsubscribe from this group, send email to
DotNetDevelopment-unsubscribe googlegroups.com
For more options, visit this group at
http:
//cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
|
|
| Re: Update data in a DataGrid |

|
2007-10-19 05:24:20 |
|
Well, that's more COM/interop than it is the debugger :P
Do you know what components you're using interop to work with? I take it you're working with an older component, in a .NET environment?
Are you using p/invoke anywhere? (DllImport) ...
On 10/19/07, Bails < andrewgbaillie gmail.com">andrewgbaillie gmail.com> wrote:
Your probably right Andrew, though I now have another example of the debugger being a bugga and spitting out gobledegook.
I have listed it below. If you can make any sense of it I'd be greatful.
All I can make out from the following error is that i dont have "referenced assembly installed" on my machine - but which reference??
***************************************************************************************
PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.1378 System.Deployment.dll : 2.0.50727.1378 (
REDBITSB2.050727-1300) mscorwks.dll : 2.0.50727.1378 (REDBITSB2.050727-1300) dfdll.dll : 2.0.50727.1378 (REDBITSB2.050727-1300) dfshim.dll :
2.0.50727.1378 (REDBITSB2.050727-1300)
SOURCES Deployment url : file:///C:/Documents%20and%20Settings/fabian/My%20Documents/Visual%20Studio%202005/Projects/Holdem%20Tournament%20Timer/Published/Holdem%20Tournament%20Timer.application
Application url : file:///C:/Documents%20and%20Settings/fabian/My%20Documents/Visual%20Studio%202005/Projects/Holdem%20Tournament%20Timer/Published/Holdem%20Tournament%20Timer_1_0_1_13/Holdem%20Tournament%20Timer.exe.manifest
IDENTITIES Deployment Identity : Holdem Tournament Timer.application, Version=1.0.1.13, Culture=en-AU, PublicKeyToken=a675fef2688dba94, processorArchitecture=msil
Application Identity : Holdem Tournament Timer.exe, Version=1.0.1.13, Culture=en-AU, PublicKeyToken=a675fef2688dba94, processorArchitecture=msil, type=win32
APPLICATION SUMMARY   | |