Null Reference Exception for Array Problem... [modified]

[rashadaliarshad]

Problem: When i fetch a list of column values from database and store them into a String One dimentional Array, it gives me exception error "Null Reference", kindly can anyone help me out, whats wrong with my code? // ========================================================================= // This is Where Problem comes - Complete code in given below // ========================================================================= myProfileNames.SetValue(pfDataSet.Tables("TimerDetails").Rows(j).Item("ProfileName").ToString, j) MsgBox(myProfileNames.GetValue(j)) // ========================================================================= Code: Public Class DataAccess Private m_strAppPath As String Private m_connectionString As String Public m_connectionObject As New OleDbConnection Private dataAdapter As OleDbDataAdapter Private pfDataSet As DataSet // One Dimentional Array to hold String Values fetched from Database... Public myProfileNames() As String // Public Subroutine that will be called through an instance of this // class. Public Sub LoadProfiles() Dim ProfileCount As Integer m_strAppPath = Directory.GetCurrentDirectory m_connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_strAppPath & "\TimerData.mdb" Try If Not (m_connectionObject.State = ConnectionState.Open) Then m_connectionObject.ConnectionString = m_connectionString m_connectionObject.Open() m_ConnectionStatus = True End If dataAdapter = New OleDbDataAdapter("Select * from ProfileMaster", m_connectionObject) pfDataSet = New DataSet("TimerDetails") dataAdapter.Fill(pfDataSet, "TimerDetails") // GET the No. of Rows that exists in Dataset ProfileCount = pfDataSet.Tables("TimerDetails").Rows.Count If Not (ProfileCount = 0) Then Dim j As Integer For j = 0 To (ProfileCount - 1) // ========================================================================= // This is Where Problem comes Stating that Null Refrence Exception occured // ========================================================================= myProfileNames.SetValue(pfDataSet.Tables("TimerDetails").Rows(j).Item("ProfileName").ToString, j) MsgBox(myProfileNames.GetValue(j)) // ==================================================

[Guffa]

It seems to be that the result doesn't have a field named "ProfileName". Do you have such a field in the table? Specify the fields that you want returned in the query, instead of using *. That makes debugging easier, plus it makes the query only fetch the data that you need.

--- single minded; short sighted; long gone;

[rashadaliarshad]

Friends, i got ma problem fixed:) // One Dimentional Array to hold String Values fetched from Database... Public myProfileNames() As String <-- Wrong Initialization public myprofileNames(10) as String <-- Problem Solved:-D But i still want to know, what if i dont know, how mnay elements my array gona contain, how to dynamically initialize array elements. anyone there for help?

:- Rashid Ali -:

[Christian Graus]

That's what classes like List ( or ArrayList in .NET 1.0 and 1.1 ) are for.

Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )