ASP.net merge two datasets
Posted on 2014-02-18
What is the easiest way to merge two datasets that have the same first two columns, and that are created using code like the following
Function GetData(ByVal queryString As String) As DataSet
Dim cs As String = ConfigurationManager.ConnectionStrings("survey_conn").ConnectionString
Dim myConnection As SqlConnection = New SqlConnection(cs)
Dim ds As New DataSet()
' Connect to the database and run the query.
Dim adapter As New SqlDataAdapter(queryString, myConnection)
' Fill the DataSet.
Catch ex As Exception
' The connection failed. Display an error message.
Me.Label_Error1.Text = "Unable to connect to the database." & Err.Description