C#

Shivendra Pandey wrote:

It means only first time the database will open from next time it use the same open connection for every request.

Shivendra Pandey wrote:

one dedicated open connection for all request in this service

String str1 = DateTime.Now.ToString("dd"); //12
String str2;

if (str1 == "01")
   str2 = "st"
else if (str1 == "02")
   str2 = "nd";
else if (str1 == "03")
   str2 = "rd";
else
   str2 = "th";

String str3 = DateTime.Now.ToString("MMM"); //Oct
String str4 = DateTime.Now.ToString("yy"); //09

String date = str1+str2+ " " + str3+ "'"+ str4; //12th Oct'09 

MSDASC.DataLinks ObjDLink;
ObjDLink= new MSDASC.DataLinks();
ObjPrompt = ObjDLink.PromptNew();
strConnectioString = ObjPrompt.ToString(); 

private void btnSearch_Click(object sender, EventArgs e)
{
    SqlDataSourceEnumerator SqlEnumerator = SqlDataSourceEnumerator.Instance;
    DataTable dt = new DataTable();
    dt = SqlEnumerator.GetDataSources();
    dataGridView1.DataSource = dt.DefaultView;
}


private void btnSave_Click(object sender, EventArgs e)
{
    if (dataGridView1.SelectedRows.Count != 0)
    {
        string ConString = "";

        SqlConnectionStringBuilder builder =new SqlConnectionStringBuilder();
        builder.ApplicationName = "MyApp";
        builder.WorkstationID = Environment.MachineName;
        builder.UserID = txtLoginName.Text.Trim();
        builder.Password = txtPassword.Text.Trim());
        builder.InitialCatalog="MyDBName";
        builder.DataSource = dataGridView1.SelectedRows[0].Cells["ServerName"].Value.ToString()+
       "\\"+dataGridView1.SelectedRows[0].Cells["InstanceName"].Value.ToString();

        ConString = builder.ConnectionString;

    }

}