How Can I Fill Data In Textboxes From Sql Databases But Two Different Tables When I Select A Name That Is Inside A Dropdownlist

HI

I need help 

how can i fill data in textboxes from sql databases but two different tables when i select a name that is inside a dropdownlist

my controls are as follows

<asp:DropDownList ID="ddl" runat="server" DataSourceID="SqlDataSource13" DataTextField="fullname" DataValueField="fullname">

</asp:DropDownList>

<asp:SqlDataSource ID="SqlDataSource13" runat="server" ConnectionString="<%$ ConnectionStrings:NPI Employee MasterConnectionString2 %>"

SelectCommand="SELECT [FirstName]+' '+ [Surname] as fullname FROM [Employee]&#13;&#10;where CurrentEmployee_YN=1&#13;&#10;order by FirstName "></asp:SqlDataSource><table bordercolor="#111111" cellpadding="0" cellspacing="0" style="width: 100%;

border-collapse: collapse; height: 32px; visibility: hidden;" id="table0">

<tr>

<td style="width: 159px; visibility: hidden;">

</td>

<td style="width: 170px">

</td>

<td bgcolor="#eeeddb" style="width: 20%; height: 25px">

<strong>

Order No：</strong></td>

<td bgcolor="#eeeddb" style="width: 26%; height: 25px">

&nbsp;<asp:Label ID="OrderNo" runat="server" Width="104px"></asp:Label></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 159px; height: 25px">

<strong>

Account No：</strong></td>

<td bgcolor="#eeeddb" style="width: 170px">

<asp:TextBox ID="AccountNo" runat="Server" MaxLength="10" Width="130px"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="AccountNo"

Display="Static" ErrorMessage="Enter Acc No." Text="*"></asp:RequiredFieldValidator></td>

<td bgcolor="#eeeddb" style="width: 20%; height: 25px">

<strong>

Today's Date:</strong></td>

<td>

<asp:Label ID="Label1" runat="server" Text="Label" Width="200px"></asp:Label></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 159px; height: 25px">

<strong>

Travel Consultant：</strong></td>

<td bgcolor="#eeeddb" style="width: 170px">

<asp:TextBox ID="Consultant" runat="Server" MaxLength="30" Width="128px"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="Consultant"

Display="Static" ErrorMessage="Enter Travel Consultant." Text="*"></asp:RequiredFieldValidator></td>

</tr>

</table>

<center>

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

</center>

<center>

&nbsp;</center><table bordercolor="#111111" cellpadding="0" cellspacing="0" style="width: 80%;

border-collapse: collapse; height: 32px; display: block; visibility: hidden;" id="table2">

<tr>

<td align="center" bgcolor="#ffcc33" colspan="3" style="width: 90%; height: 29px">

<font color="#000000" size="5">Enter Passenger(s) Details</font></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 25px">

<strong>

Surname：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<asp:TextBox ID="Surname" runat="Server" MaxLength="30" Width="148px"></asp:TextBox>

&nbsp; &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="Surname" Display="Static" ErrorMessage="Enter Surname." Text="*"></asp:RequiredFieldValidator></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 20px">

<strong>

Name：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 20px">

<asp:TextBox ID="Name" runat="Server" MaxLength="30" Width="148px"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="Name"

Display="Static" ErrorMessage="Enter Name." Text="*"></asp:RequiredFieldValidator></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 25px">

<strong>

Initials：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<asp:TextBox ID="Initials" runat="Server" MaxLength="5" Width="148px"></asp:TextBox>

 

</td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 25px">

<strong>

Title：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<asp:DropDownList ID="DropDownList1" runat="server" Width="156px">

<asp:ListItem></asp:ListItem>

<asp:ListItem Value="Mr"></asp:ListItem>

<asp:ListItem Value="Mrs"></asp:ListItem>

<asp:ListItem Value="Ms"></asp:ListItem>

<asp:ListItem Value="Dr"></asp:ListItem>

<asp:ListItem Value="Prof"></asp:ListItem>

<asp:ListItem Value="Min"></asp:ListItem>

<asp:ListItem Value="Other"></asp:ListItem>

</asp:DropDownList>&nbsp;

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="Dropdownlist1"

Display="Static" ErrorMessage="Select Title." Text="*" Width="20px"></asp:RequiredFieldValidator>

</td>

</tr>

<tr><td bgcolor="#eeeddb">

<strong>

Department</strong>

</td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<asp:TextBox ID="Department" runat="server"></asp:TextBox></td>

</tr>

<tr><td bgcolor="#eeeddb">

<strong>

Cost Centre</strong>

</td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<asp:TextBox ID="CostCentre" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 25px">

<strong>

Tel：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<input id="Tel" runat="SERVER" maxlength="15" name="Tel" onkeypress="if((event.keyCode<48)|| (event.keyCode>57))event.returnValue=false"

style="width: 143px" type="text" />

&nbsp;&nbsp;

</td>

</tr>

<tr>

<td bgcolor="#eeeddb" style="width: 31%; height: 25px">

<strong>

Fax：</strong></td>

<td bgcolor="#eeeddb" style="width: 57%; height: 25px">

<input id="Fax" runat="SERVER" maxlength="15" name="Fax" onkeypress="if((event.keyCode<48)|| (event.keyCode>57))event.returnValue=false"

style="width: 143px" type="text" />

</td>

</tr>

</table>

cost centre and department are from cost table

and the rest are from employee table