|
namespace ConnectionStrBuilderSample
{
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
public partial class FrmGiris : Form
{
SqlConnectionStringBuilder parametreler;
SqlConnection baglantiNesnesi;
public FrmGiris()
{
InitializeComponent();
parametreler = new SqlConnectionStringBuilder();
baglantiNesnesi = new SqlConnection();
}
private void btnbaglan_Click(object sender, EventArgs e)
{
parametreler.DataSource = txt_sunucu.Text.Trim();
parametreler.InitialCatalog = txt_veritabani.Text.Trim();
parametreler.ApplicationName = Application.ProductName;
parametreler.UserID = txt_kullanici.Text.Trim();
parametreler.Password = txt_parola.Text.Trim();
parametreler.ConnectTimeout = int.Parse(txt_zamanasimi.Text.Trim());
if (chkWinKimlik.Checked==true) parametreler.IntegratedSecurity = true;
txt_parametreler.Text = parametreler.ConnectionString;
try
{
baglantiNesnesi.ConnectionString = this.parametreler.ConnectionString;
baglantiNesnesi.Close();
baglantiNesnesi.Open();
}
catch (SqlException hata)
{
txt_error.Text = hata.StackTrace.ToString();
tabControl1.SelectedTab=tabControl1.TabPages[1];
}
}
private void chkWinKimlik_CheckedChanged(object sender, EventArgs e)
{
switch (chkWinKimlik.CheckState)
{
case CheckState.Checked:
{
txt_kullanici.Enabled = false;
txt_parola.Enabled = false;
break;
}
case CheckState.Unchecked:
{
txt_kullanici.Enabled = true;
txt_parola.Enabled = true;
break;
}
}
}
private string BaglantiNeDurumda()
{
string haticeNetice;
switch (baglantiNesnesi.State)
{
case ConnectionState.Broken: haticeNetice = "Kirik";
break;
case ConnectionState.Closed: haticeNetice = "Kapali";
break;
case ConnectionState.Connecting: haticeNetice = "Baglaniliyor";
break;
case ConnectionState.Executing: haticeNetice = "Sorgu isletiliyor";
break;
case ConnectionState.Fetching: haticeNetice = "veri akisi var";
break;
case ConnectionState.Open: haticeNetice = "Bagli...";
break;
default: haticeNetice = "...";
break;
}
return haticeNetice;
}
private void HerSaniyeDurumGoster_Tick(object sender, EventArgs e)
{
this.lbldurum.Text = this.BaglantiNeDurumda();
}
}
}
|