Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.30 KB | None | 0 0
  1. void GetAddressFromCboExternal()
  2.         {
  3.  
  4.             string Server = "xxxxx\\xxxxxxxxx";
  5.             string Username = "xxxx";
  6.             string Password = "xxxxxx";
  7.             string Database = "Contacts";
  8.  
  9.             string ConnectionString = "Data Source=" + Server + ";";
  10.             ConnectionString += "User ID=" + Username + ";";
  11.             ConnectionString += "Password=" + Password + ";";
  12.             ConnectionString += "Initial Catalog=" + Database;
  13.  
  14.  
  15.             string ToExternal = Convert.ToString(lstToExternal.Items[0]);
  16.             SqlConnection SQLConnection = new SqlConnection();
  17.  
  18.             string SQLStatement = "SELECT dbo.ADDRESS_SQL.Address, dbo.ADDRESS_SQL.City, dbo.ADDRESS_SQL.Zip FROM dbo.ADDRESS_SQL INNER JOIN                      dbo.NAME ON dbo.ADDRESS_SQL.Name_Rec = dbo.NAME.Name_Rec WHERE (dbo.NAME.First_Name + " + " " + " dbo.NAME.Last_Name = " + ToExternal + ")";
  19.  
  20.             SQLConnection.ConnectionString = ConnectionString;
  21.             SQLConnection.Open();
  22.  
  23.             SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLStatement, SQLConnection);
  24.  
  25.  
  26.             Globals.ThisDocument.txtTo.Text = SQLDataAdapter.ToString();
  27.             SQLDataAdapter.Dispose();
  28.  
  29.             SQLConnection.Close();
  30.             SQLConnection.Dispose();
  31.  
  32.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement