Object Reference Error filling a datarow

Posted by JPJedi on Stack Overflow See other posts from Stack Overflow or by JPJedi
Published on 2010-02-23T22:22:00Z Indexed on 2010/03/25 20:53 UTC
Read the original article Hit count: 430

Filed under:

datarow

|

dataset

|

datatable

|

datatable.select

This is the code:

Dim dr() As DataRow = DataSet.Tables("TableName").Select("EVENTNAME = '" & name & "'")

I get an "Object reference not set to an instance of an object." Error when this line is executed. It is looping through a list of selected items in a listbox. I think it has to do with how I have the datarow declared because I can look at the name and I see it ok and I also do a null check on the name before I use it.

Visual Studio 2008, VB.NET. Any ideas?

Yep it was a wrong table name. I guess after looking at the code for 8 hours that minor detail I just wasn't thinking to check. Thanks!

© Stack Overflow or respective owner

Related posts about datarow

Creating a Dynamic DataRow for easier DataRow Syntax

as seen on West-Wind - Search for 'West-Wind'
I've been thrown back into an older project that uses DataSets and DataRows as their entity storage model. I have several applications internally that I still maintain that run just fine (and I sometimes wonder if this wasn't easier than all this ORM crap we deal with with 'newer' improved technology… >>> More
Different between &$DataRow and $DataRow

as seen on Stack Overflow - Search for 'Stack Overflow'
hi guys, I am confused from the result of the following code: I can't get my expected result: $arrX = array('a'=>array('val'=>10),'b'=>array('val'=>20), 'c'=>array('val'=>30)); foreach( $arrX as &$DataRow ) { $DataRow['val'] = $DataRow['val'] + 20; } foreach( $arrX as $DataRow… >>> More
vs2003 : assign datarow object

as seen on Stack Overflow - Search for 'Stack Overflow'
currently I am doing this... object s = new object(); ... s = mydatarow["mycolumn"]; What I would like to do is... DataRow r = null; ... r = mydatarow["mycolumn"]; and I get an error saying that can not covert from object to DataRow.. is there a better way of doing this? >>> More
How to Assign a datarow object in .NET 1.1

as seen on Stack Overflow - Search for 'Stack Overflow'
currently I am doing this... object s = new object(); s = mydatarow["mycolumn"]; What I would like to do is... DataRow r = null; r = mydatarow["mycolumn"]; and I get an error saying that can not covert from object to DataRow. is there a better way of doing this? >>> More
vs2003: identify first row in DataRow[]

as seen on Stack Overflow - Search for 'Stack Overflow'
what is the best way to identify first row in the following code? foreach(DataRow row in myrows) { if (first row ) { ...do this... } else { ....process other than first rows.. } } >>> More

Related posts about dataset

Dataset -> XML Document - Load DataSet into an XML Document - C#.Net

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I'm trying to read a dataset as xml and load it into an XML Document. XmlDocument contractHistoryXMLSchemaDoc = new XmlDocument(); using (MemoryStream ms = new MemoryStream()) { //XmlWriterSettings xmlWSettings = new XmlWriterSettings(); //xmlWSettings.ConformanceLevel = ConformanceLevel… >>> More
Combine multiple dataset columns to one dataset

as seen on Stack Overflow - Search for 'Stack Overflow'
I have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query… >>> More
Making a DataSet from another DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi folks I have a client-server project (small project for companies in C#) and the server has a DataSet with some tables (there is no Database for some reasons so we save the DataSet as an XML file). when the clients connect to the server, the server should send some informations to the client depends… >>> More
Declaring variables with New DataSet vs DataSet

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the impact of creating variables using: Dim ds as New DataSet ds = GetActualData() where GetActualData() also creates a New DataSet and returns it? Does the original empty DataSet that was 'New'ed just get left in the Heap? What if this kind of code was in many places? Would… >>> More
DataSet.Copy vs Dataset.Clone

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone explain me DataSet.Copy vs Dataset.Clone Also let me know some scenario's where we can use these >>> More