Advertisement
c_inek

Untitled

Nov 21st, 2014
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.70 KB | None | 0 0
  1. private void button1_Click(object sender, EventArgs e) //login haslo
  2.         {
  3.             string connetionString;
  4.             SqlConnection connection;
  5.             string login = textBox1.Text;
  6.             string password = textBox2.Text;
  7.             connetionString = "Data Source="+serverName+";Initial Catalog=GeneralDzordan;User ID=" + login + ";Password=" + password;
  8.             connection = new SqlConnection(connetionString);
  9.             try
  10.             {
  11.                 connection.Open();
  12.                 MessageBox.Show ("Connection Open!");
  13.                 connection.Close();
  14.             }
  15.             catch (Exception ex)
  16.             {
  17.                 MessageBox.Show("Nie można ustanowić połączenia! \nError: "+ ex.Message);
  18.             }
  19.         }
  20.  
  21.         private void button2_Click(object sender, EventArgs e) //windows autentyfication
  22.         {
  23.             string connetionString;
  24.             SqlConnection connection;
  25.             string login = textBox1.Text;
  26.             string password = textBox2.Text;
  27.             connetionString = "Data Source="+serverName+";Initial Catalog=GeneralDzordan;User ID=" + login + ";Password=" + password;
  28.  
  29.             connetionString = "data source=localhost;initial catalog=GeneralDzordan;persist security info=True;Integrated Security=SSPI";
  30.  
  31.  
  32.             connection = new SqlConnection(connetionString);
  33.             try
  34.             {
  35.                 connection.Open();
  36.                 MessageBox.Show ("Connection Open!");
  37.                 connection.Close();
  38.             }
  39.             catch (Exception ex)
  40.             {
  41.                 MessageBox.Show("Nie można ustanowić połączenia! \nError: "+ ex.Message);
  42.             }
  43.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement