need to get two database values of two storeprocedure value in one gridview to compare there values

Will you please explain your requirement in more details with an example

i want to get  value from two different database(different connection string) storeprocedure in one gridview

    Dim myConnection As SqlConnection = New System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("connTemplate").ConnectionString)
    Dim myCommand As SqlCommand
    Dim myReader As SqlDataReader
    Dim SQL As String

    Dim myConnection2 As SqlConnection = New System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("connBackUp").ConnectionString)
    Dim myCommand2 As SqlCommand

    Sub storep()
        Dim strConnString As String = ConfigurationManager.ConnectionStrings("connTemplate").ConnectionString
        Dim con As New SqlConnection(strConnString)
        Dim cmd As New SqlCommand()
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "storeroom"
        cmd.Connection = con
        Try
            con.Open()
            GridView1.EmptyDataText = "No Records Found"
            GridView1.DataSource = cmd.ExecuteReader()
            GridView1.DataBind()
        Catch ex As Exception
            Throw ex
        Finally
            con.Close()
            con.Dispose()
        End Try

    End Sub
    Sub storep_Backup()
        Dim strConnString As String = ConfigurationManager.ConnectionStrings("connBackUp").ConnectionString
        Dim con As New SqlConnection(strConnString)
        Dim cmd As New SqlCommand()
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "storeroom"
        cmd.Connection = con
        Try
            con.Open()
            GridView2.EmptyDataText = "No Records Found"
            GridView2.DataSource = cmd.ExecuteReader()
            GridView2.DataBind()
        Catch ex As Exception
            Throw ex
        Finally
            con.Close()
            con.Dispose()
        End Try

    End Sub

Hi,

Simply you can get data of both the databases like below

SQL

SELECT [CustomerId]
    ,[Name]
    ,[Country]
FROM [Sample].[dbo].[Customers]
UNION ALL
SELECT [CustomerId]
    ,[Name]
    ,[Country]
FROM [Test].[dbo].[Customers]

I hope this will help you out.

is this code work with in the different sources

 192.168.25.25(Initial Catalog=STORE)(StoredProcedure =  storeroom)

192.168.25.26(Initial Catalog=STORE)(StoredProcedure =  storeroom)

  <add name="connTemplate" connectionString="Data Source=192.168.25.25;Initial Catalog=STORE;User ID=ST;Password=ST123;Connect Timeout=200; pooling='true'; Max Pool Size=200"
   providerName="System.Data.SqlClient" />
  <add name="connBackUp" connectionString="Data Source=192.168.25.26;Initial Catalog=STORE;User ID=ST;Password=ST123;Connect Timeout=200; pooling='true'; Max Pool Size=200"
   providerName="System.Data.SqlClient" />