[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Datatable Null Exception

Hello,

I'm creating a Windows application using Access database as the backend.

What I want to achieve is to search for an record in the database using a datagridview and update the table.
I have button for "Update", but it's throwing an Nullexception error. My database table does have null values in it.

Private dt as dataset = nothing
Dim dt As DataTable  = ds.Tables("TBL_ASSETS")
        Me.TBL_ASSETSDataGridView.BindingContext(dt).EndCurrentEdit()
        Me.TBL_ASSETSDataGridView.Update()

Can someone please assist?
Thank you
0
angel7170
Asked:
angel7170
1 Solution
 
kovilpattiBaluCommented:
Check before End edit  like this..

if (control.DataBindings.Count > 0)
   {
      control.DataBindings[0].BindingManagerBase.EndCurrentEdit();
   }
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now