Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void btnTestOracle_Click(object sender, EventArgs e)
- {
- EMPLOYEESRECORDSELECT[] selectRecords = new EMPLOYEESRECORDSELECT[0];
- // Initialize WCF client variables
- HR_Table_EMPLOYEESClient aaTableClient = null;
- try
- {
- // initialize the EMPLOYEES table client
- aaTableClient = new HR_Table_EMPLOYEESClient("OracleDBBinding_HR_Table_EMPLOYEES");
- //Security Credentials
- aaTableClient.ClientCredentials.UserName.UserName = "HR";
- aaTableClient.ClientCredentials.UserName.Password = "welkom";
- //Open Client
- aaTableClient.Open();
- // Select all records and write them to the textbox result
- selectRecords = aaTableClient.Select("*", "LAST_NAME = '" + txtLastName.Text + "'");
- txtResultOracle.Text = "First Name :" + selectRecords[0].FIRST_NAME + "\r\n" + "Email :" + selectRecords[0].EMAIL + "\r\n" + "Phone Number : " + selectRecords[0].PHONE_NUMBER;
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- finally
- {
- aaTableClient.Close();
- }
- }
Add Comment
Please, Sign In to add comment