private void buttonTest_Click(object sender, EventArgs e)<\/div>
{<\/div>
//////////////////////////////////////////////////////////////////////<\/div>
// CREATING THE CLIENT<\/div>
///////////////////////////////////////////////////////////////////////<\/div>
<\/div>
Procedures_dboClient client = new Procedures_dboClient("SqlAdapterBinding_Procedures_dbo");<\/div>
<\/div>
//Windows Authentication<\/div>
<\/div>
///////////////////////////////////////////////////////////////////////<\/div>
// OPENING THE CLIENT<\/div>
///////////////////////////////////////////////////////////////////////<\/div>
<\/div>
try<\/div>
{<\/div>
Console.WriteLine("Opening Client...");<\/div>
client.Open();<\/div>
}<\/div>
catch (Exception ex)<\/div>
{<\/div>
Console.WriteLine("Exception: " + ex.Message);<\/div>
throw;<\/div>
}<\/div>
<\/div>
///////////////////////////////////////////////////////////////////////<\/div>
// EXECUTING THE GET_EMP_DETAILS STORED PROCEDURE<\/div>
///////////////////////////////////////////////////////////////////////<\/div>
<\/div>
DataSet[] dataArray;<\/div>
int returnCode;<\/div>
<\/div>
try<\/div>
{<\/div>
Console.WriteLine("Calling a stored procedure...");<\/div>
dataArray = client.uspGetEmployeeDetail(textBoxNationalIDNumber.Text, out returnCode);<\/div>
}<\/div>
catch (Exception ex)<\/div>
{<\/div>
Console.WriteLine("Exception: " + ex.Message);<\/div>
throw;<\/div>
}<\/div>
Console.WriteLine("The details for the employee with NationalIDNumber are: {0}", textBoxNationalIDNumber.Text);<\/div>
Console.WriteLine("*************************************************");<\/div>
<\/div>
textBoxResult.Text = dataArray[0].Any1.FirstChild.InnerXml;<\/div>
<\/div>
/////////////////////////////////////////////////////////////////////////<\/div>
// CLOSING THE CLIENT<\/div>
/////////////////////////////////////////////////////////////////////////<\/div>
<\/div>
client.Close();<\/div>
Console.WriteLine("Press any key to exit...");<\/div>
Console.ReadLine(); <\/div>
<\/div>
}<\/div><\/pre><\/div>\n \n <\/div>\n\n