Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void GetAddressFromCboExternal()
- {
- string Server = "xxxxx\\xxxxxxxxx";
- string Username = "xxxx";
- string Password = "xxxxxx";
- string Database = "Contacts";
- string ConnectionString = "Data Source=" + Server + ";";
- ConnectionString += "User ID=" + Username + ";";
- ConnectionString += "Password=" + Password + ";";
- ConnectionString += "Initial Catalog=" + Database;
- string ToExternal = Convert.ToString(lstToExternal.Items[0]);
- SqlConnection SQLConnection = new SqlConnection();
- 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 + ")";
- SQLConnection.ConnectionString = ConnectionString;
- SQLConnection.Open();
- SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLStatement, SQLConnection);
- Globals.ThisDocument.txtTo.Text = SQLDataAdapter.ToString();
- SQLDataAdapter.Dispose();
- SQLConnection.Close();
- SQLConnection.Dispose();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement