ok, but I still think using sessions is much more effective :P. I used to
code cms systems in PHP. User logged in (or sent some information), those
were processed and saved into sessions. It is simple, fast and quite
secured.

2009/7/3 The_Fruitman <evilfruitsmas...@gmail.com>

I am not sure if this will help... So it is an asp.net application? If it
is, then you can use Sessions. Every session is unique for each user

2009/7/3 Vineet <vineet.deod...@gmail.com>

You'd better use Web Service or remoting, the client app won't store
connection. It should be store on the server that offer web service.

Take this for your reference, hope this helps. If you want any detail help,
please tell us.
http://www.codeproject.com/KB/webservices/myservice.aspx

Hello Vineet let me know that this is ryt or wrong

1.You want to connect to dynamic Database?
2. You want to Build Connection String Dynamically?
3.You want to access 1st Connection String from app.config file??

Answer these and i will try to help..

Think Before you print: Please consider our environment before printing this
e-mail
Fred Allen <http://www.brainyquote.com/quotes/authors/f/fred_allen.html>  -
"California is a fine place to live - if you happen to be an orange."

Thanks,
Vineet.
--------------------------------------------------------------------------- ------------------------------------

Hi
Vineet

Here's the Solution you can try with this
If any error please let me know.. Even i am using the same if any variables
or something missing let me know

Just i have Declared Some *Global Variables* here [?]

Module GlbVariables

    Public glb_DBUserid As String
    Public glb_DBPassword As String
    Public glb_DBName As String
    Public glb_ServerName As String

End Module

*App.congif file connection String* [?]

    <connectionStrings>
          <add name="DefaultConnectionStringToMasterDatabase"
connectionString="Data Source=ServerName;Initial Catalog=Master;integrated
security=True;uid=UserName;pwd=Password"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

*
'SQL DATA Manager Class *[?]

This Below Class uses the Master database Connection String and then
Connects to the Databse which is Stored in the Global Variable with UserId
and Password..

If any error in the code please let me know

Imports System.Data.SqlClient
Imports System.Configuration

Namespace DataManager

   Public Class SqlServerDataManager

#Region "Private Attributes"
        Private m_ConnectionString As String
        Public m_Connection As SqlConnection
        Private m_Command As SqlCommand
        Private m_DataAdapter As SqlDataAdapter
        Private m_CommandBuilder As SqlCommandBuilder
        Private StrSql As String
#End Region

        'Constructor
        Public Sub New()
        'In Below Line i have connected to the Master database this is
mandatory and after that we can build connectionstring Dynamically as shown
below
            m_ConnectionString =
ConfigurationManager.ConnectionStrings("DefaultConnectionStringToMasterData base").ConnectionString

          Dim ConnStrBuiler As New
SqlConnectionStringBuilder(m_ConnectionString)
            Dim PrevYearConnStr    Builer As New
SqlConnectionStringBuilder(m_ConnectionString)

            Try
                If Len(glb_DBName) <= 0 Then
                    m_Connection = New
Data.SqlClient.SqlConnection(m_ConnectionString)
                Else
                    ConnStrBuiler.InitialCatalog = glb_DBName
                    m_Connection = New
Data.SqlClient.SqlConnection(ConnStrBuiler.ToString())
                End If

                glb_DBUserid = ConnStrBuiler.UserID
                glb_DBPassword = ConnStrBuiler.Password
                glb_ServerName = ConnStrBuiler.DataSource
                glb_strConnString = ConnStrBuiler.ToString()

                m_Command = New Data.SqlClient.SqlCommand
                m_Command.Connection = m_Connection
                m_Command.CommandType = CommandType.Text

            Catch ex As System.InvalidOperationException
                MessageBox.Show(ex.Message.ToString)

            Catch ex As Exception
                MessageBox.Show(ex.Message.ToString)
            End Try
        End Sub

'And a Test Query for the above code
'Wrote a function which Executes the Query sent as parameter and returns the
value

 Public Function GetValue(ByVal SQL As String) As Object
            ' Function will return First-Row First-Column result of
executing SQL Query over Access Database
            If m_Connection.State = ConnectionState.Open Then
                m_Connection.Close()
            End If

            If SQL.Length <= 0 Then
                Throw New InvalidExpressionException
            End If

            Dim oObject As Object
            m_Command.CommandText = SQL
            m_Command.CommandType = CommandType.Text

            Try
                m_Connection.Open()
                oObject = m_Command.ExecuteScalar()
                m_Connection.Close()
                Return oObject

            Catch ex As System.Data.SqlClient.SqlException
                ' Closing connection
                Call CloseConnectionObject()
                Throw New InvalidExpressionException(ex.Message.ToString)
            Catch ex As System.InvalidOperationException
                ' Closing connection
                Call CloseConnectionObject()
                Throw New InvalidOperationException(ex.Message.ToString)
            Catch ex As Exception
                ' Closing connection
                Call CloseConnectionObject()
                Throw New Data.DataException
            Finally
                ' Closing connection
                Call CloseConnectionObject()
            End Try

        End Function

Public Sub CloseConnectionObject()

            ' Closing connection
            If m_Connection.State = ConnectionState.Open Then
                m_Connection.Close()
            End If
            If Not IsNothing(m_DataAdapter) Then
                m_DataAdapter.Dispose()
            End If
            If Not IsNothing(m_CommandBuilder) Then
                m_CommandBuilder.Dispose()
            End If
        End Sub

    End Class

End Namespace

I think this will help you a lot ..[?][?][?][?]

Think Before you print: Please consider our environment before printing this
e-mail
Adrienne Gusoff<http://www.brainyquote.com/quotes/authors/a/adrienne_gusoff.html>
- "Opportunity knocked. My doorman threw him out."

332.gif < 1K Download

981.gif < 1K Download

360.gif < 1K Download

983.gif < 1K Download

---Vineet.