Error: Value of type '1-dimensional array of System.Data.Dataset' cannot be converted

[marylipscomb]

I am using VB.NET. I am trying to connect a button so that when it is clicked the gridview pops up the data.


Partial Class Switchboard
Inherits System.Web.UI.Page
Protected Sub btnLookup_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLookup.Load
If Not Page.IsPostBack Then
Dim queryString As String = "Select CompanyID As CompanyID, Company As Company, [City Location] As [City Location], [Invest Status] As [Invest Status], Phone As Phone, [Fist Name] + ' ' + [Last Name] As Contact From(Companies)"
Dim ds As System.Data.DataSet = GetData(queryString)
If (ds.Tables.Count > 0) Then
GVCompany.DataSource = ds
GVCompany.DataBind()
Else
lblMessage.Text = "Unable to connect to the database."

End If

End If
End Sub
Function GetData(ByVal queryString As String) As System.Data.DataSet()
Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("Connection String").ConnectionString
Dim ds As New System.Data.DataSet()
Try
Dim connection As New System.Data.SqlClient.SqlConnection(ConnectionStri ng)
Dim adapter As New System.Data.SqlClient.SqlDataAdapter(queryString, connection)
adapter.Fill(ds)
Catch ex As Exception
'Message.Text = "Unable to connect to the database."
End Try
Return ds
Try

Catch ex As Exception

End Try
End Function



End Class


The error I am getting is this :

Value of type '1-dimensional array of System.Data.Dataset'
cannot be converted to 'System.Data.Dataset'.

I am having so much trouble with this.. help would be so appreciated..

thanks!!!!!

[Plater]

Your function returns an array of dataset

Function GetData(ByVal queryString As String) As System.Data.DataSet()
 

Try this:

Function GetData(ByVal queryString As String) As System.Data.DataSet
 

[marylipscomb]

now I am getting this error when I go to the page.




Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 18: End Sub
Line 19: Function GetData(ByVal queryString As String) As System.Data.DataSet
Line 20: Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("Connection String").ConnectionString
Line 21: Dim ds As New System.Data.DataSet
Line 22: Try


Source File: V:\inetpub\wwwroot\WVDODevSite\Switchboard.aspx.vb Line: 20

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
Switchboard.GetData(String queryString) in V:\inetpub\wwwroot\WVDODevSite\Switchboard.aspx.vb :20
Switchboard.btnLookup_Load(Object sender, EventArgs e) in V:\inetpub\wwwroot\WVDODevSite\Switchboard.aspx.vb :8
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

[Plater]

Is this the offending line?

Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
 

[marylipscomb]

yes thats the problem

[marylipscomb]

Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("Connection String").ConnectionString




is ("ConnectionString") where I put my connection string??? for example it would look like this:

Dim ConnectionString As String = ConfigurationManager.ConnectionStrings
(Data Source=MLIPSCOMB737; Initial Catalog=BID; Integrated Security = True.ConnectionString

???
Thanks for all your help!!!!

[Plater]

No, that is where it is referencing the connectionstrings section of your web.config file.
Do you have a connectionstring in there?

Something like:

<connectionStrings>
   <add name="myconstring" connectionString="Data Source=MLIPSCOMB737; Initial Catalog=BID; Integrated Security = True"/>
</connectionStrings>
 

then you would do:

Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("myconstring").ConnectionString
 

(I think)