Solved

Datatable Null Exception

Posted on 2010-09-20
1
318 Views
Last Modified: 2013-11-26
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
Comment
Question by:angel7170
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
kovilpattiBalu earned 500 total points
ID: 33716367
Check before End edit  like this..

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

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question