G
Guest
I am experiencing an error when I run the following code:
Dim dsServer As New DataSet
Dim cmdServer As New SqlCommand
Dim sSelect As String = "SELECT tblServer.DNSName FROM tblServer WHERE
tblServer.ServerID = " & Integer.Parse(Request.QueryString("ID"))
cmdServer.CommandText = sSelect
cmdServer.Connection = SqlConnection1
Dim daServer As New SqlDataAdapter
daServer.SelectCommand = cmdServer
daServer.MissingSchemaAction = MissingSchemaAction.AddWithKey
daServer.Fill(dsServer)
Dim drServer As DataRow
Dim iCurrentRow As Integer
drServer = dsServer.Tables("tblServer").Rows(iCurrentRow)
txtDNSName.Text = drServer("DNSName")
Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.
Source Error:
Line 47: Dim drServer As DataRow
Line 48: Dim iCurrentRow As Integer
Line 49: drServer = dsServer.Tables("tblServer").Rows(iCurrentRow)
Line 50: txtDNSName.Text = drServer("DNSName")
Line 51:
Source File: c:\inetpub\wwwroot\ITApplications\ServerDetail.aspx.vb Line:
49
What am I not correctly setting. Any help would be appreciated.
Dim dsServer As New DataSet
Dim cmdServer As New SqlCommand
Dim sSelect As String = "SELECT tblServer.DNSName FROM tblServer WHERE
tblServer.ServerID = " & Integer.Parse(Request.QueryString("ID"))
cmdServer.CommandText = sSelect
cmdServer.Connection = SqlConnection1
Dim daServer As New SqlDataAdapter
daServer.SelectCommand = cmdServer
daServer.MissingSchemaAction = MissingSchemaAction.AddWithKey
daServer.Fill(dsServer)
Dim drServer As DataRow
Dim iCurrentRow As Integer
drServer = dsServer.Tables("tblServer").Rows(iCurrentRow)
txtDNSName.Text = drServer("DNSName")
Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.
Source Error:
Line 47: Dim drServer As DataRow
Line 48: Dim iCurrentRow As Integer
Line 49: drServer = dsServer.Tables("tblServer").Rows(iCurrentRow)
Line 50: txtDNSName.Text = drServer("DNSName")
Line 51:
Source File: c:\inetpub\wwwroot\ITApplications\ServerDetail.aspx.vb Line:
49
What am I not correctly setting. Any help would be appreciated.