how to bind the data form dAtabase in c#...
<%@ Page Language="C#" MasterPageFile="~/AdminMaster.master" AutoEventWireup="true" CodeFile="CompetitionApplication.aspx.cs" Inherits="admin_CompetitionApplication" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label1" runat="server" Text="Student_id"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
                <asp:Button ID="Button1" runat="server" Text="Get" OnClick="Button1_Click" />
                &nbsp; &nbsp; &nbsp; &nbsp;
                <asp:Label id="lblStudent_id" runat="server"></asp:Label></td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label3" runat="server" Text="Select Country"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label4" runat="server" Text="Select State"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label5" runat="server" Text="Select Franchise"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label6" runat="server" Text="Select Sensei"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:DropDownList ID="ddlSensei" runat="server" Width ="150">
                </asp:DropDownList></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label7" runat="server" Text="Enter Student Name"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label8" runat="server" Text="Enter Student Address"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label9" runat="server" Text="Student's Father Name"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label10" runat="server" Text="Student DOB"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox10" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label11" runat="server" Text="Gender"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:RadioButton ID="RadioButton1" runat="server" Text="Male" GroupName="Gender" />
                <asp:RadioButton ID="RadioButton2" runat="server" Text="Female" GroupName="Gender" /></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px">
                <asp:Label ID="Label2" runat="server" Text="Group"></asp:Label></td>
            <td style="width: 120px; height: 32px">
                &nbsp;<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px">
                <asp:Label ID="Label12" runat="server" Text="Enter Kyu"></asp:Label></td>
            <td style="width: 120px; height: 32px">
                <asp:TextBox ID="TextBox11" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
            </td>
            <td style="width: 120px; height: 32px;">
                <asp:Button ID="Button2" runat="server" Text="Save" OnClick="Button2_Click" /></td>
            <td style="width: 205px; height: 32px;">
                <asp:Button ID="Button4" runat="server" Text="Delete" OnClick="Button4_Click" />&nbsp;&nbsp;
                &nbsp;
                <asp:Label ID ="lblDelete" runat ="server"></asp:Label></td>
        </tr>
    </table>
    <table style="width: 560px; height: 8px">
        <tr>
            <td style="width: 184px">
            </td>
            <td style="width: 158px">
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="Hall Ticket" /></td>
            <td style="width: 204px">
            </td>
        </tr>        
    </table>  
     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:semascon %>"
             SelectCommand="select  case when len(T.hallticketno)=1 then '0000'+ convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=2 then '000'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=3  then '00'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=4  then '0'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=5  then  Convert(varchar(20),T.hallticketno)  end as Hallticketno &#13;&#10;,T.Studentname,(select senseiname from senseimaster where senseiid=T.senseiID) as SenseiName,(select kyuname from kyumaster where kyuid= T.kyuid) as Kyu,(select groupname from groupmaster where groupid= T.groupid) as GroupName,T.Fathername,convert(varchar(20),T.dob,103) as Dob,  case when T.sex=0 then 'Male' else 'Female' end as Gender&#13;&#10;from applicationForm T  where Franchiseid =@FRANCHISEID and Competitionid=@competitionId&#13;&#10;order by groupname ">
    </asp:SqlDataSource>
  <%--  <asp:Repeater ID ="Repeater1" runat ="server" Visible ="false"  >--%>
    <%--<HeaderTemplate>
        <table border="1" cellpadding="5" cellspacing="2">
        <tr bgcolor="gray">
        <td><b>CompanyName</b>
        </td>
        <td><b>City</b></td>
        </tr>
        </HeaderTemplate>
         <ItemTemplate>
         <tr>
         <td>
         <%#DataBinder.Eval(Container.DataItem, "CompanyName")%>
         </td>
             <td>
         <%#DataBinder.Eval(Container.DataItem, "City")%>   
             </td>
             </tr>
         </ItemTemplate> --%>       
                        
         
         
    <table id ="sample " border ="1px" visible ="false" >    
        <tr>
        <asp:Label ID="Label13" runat ="server" Font-Bold="true" Text ='<%#Bind(CompetitionName)%>' ></asp:Label><td style="width: 100px">            
            </td>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
            </td>
        </tr>     
        <tr>
            <td style="width: 100px">
                Venue</td>
            <td style="width: 106px">
            <asp:Label ID="Label14" runat ="server" Font-Bold="true" Text ='<%Bind(competitionaddress) %>'  ></asp:Label>
            </td>
            <td style="width: 127px">
                Date of Competition</td>
            <td style="width: 129px">
            <asp:Label ID ="Label15" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
                Hall Ticket No</td>
            <td style="width: 106px">
            <asp:Label Font-Bold="true" Font-Size="X-Large"  ID="Label16" runat="server"  ></asp:Label>	
            </td>
            <td style="width: 127px">
                Group</td>
            <td style="width: 129px">
            <asp:Label ID="Label17" runat="server"  Font-Bold="true"></asp:Label>
            <%--<asp:Label ID="Lable1" runat ="server" Font-Bold="true"  Text ='<%Bind("GroupName")%>'></asp:Label>--%>
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
                Student Name</td>
            <td style="width: 106px">
            <asp:Label  ID ="Lable18" runat ="server" ></asp:Label>
            </td>
            <td style="width: 127px">
                Kyu</td>
            <td style="width: 129px">
            <asp:Label ID="Lable19" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td rowspan="3" style="width: 100px">
            </td>
            <td style="width: 106px">
            <asp:Label ID ="Lable20" runat ="server" ></asp:Label>
            </td>
            <td style="width: 127px">
                Franchise Name</td>
            <td style="width: 129px">
            <asp:Label ID ="Lable21" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
                Sensei's Name</td>
            <td style="width: 129px">
            <asp:Label ID ="Lable22" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
            </td>
            <td style="width: 106px">
                Signature of HO</td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
                Signature of Student</td>
        </tr>
    </table>
   
     
    <%--</asp:Repeater> --%>
</asp:Content>


if i click the Hall Ticket then the data sholud be bound to particular field...how to do friends plz help me...

how to bind the data form dAtabase in c#...
===

<%@ Page Language="C#" MasterPageFile="~/AdminMaster.master" AutoEventWireup="true" CodeFile="CompetitionApplication.aspx.cs" Inherits="admin_CompetitionApplication" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label1" runat="server" Text="Student_id"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
                <asp:Button ID="Button1" runat="server" Text="Get" OnClick="Button1_Click" />
                &nbsp; &nbsp; &nbsp; &nbsp;
                <asp:Label id="lblStudent_id" runat="server"></asp:Label></td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label3" runat="server" Text="Select Country"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label4" runat="server" Text="Select State"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label5" runat="server" Text="Select Franchise"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label6" runat="server" Text="Select Sensei"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:DropDownList ID="ddlSensei" runat="server" Width ="150">
                </asp:DropDownList></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label7" runat="server" Text="Enter Student Name"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label8" runat="server" Text="Enter Student Address"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label9" runat="server" Text="Student's Father Name"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label10" runat="server" Text="Student DOB"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:TextBox ID="TextBox10" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
                <asp:Label ID="Label11" runat="server" Text="Gender"></asp:Label></td>
            <td style="width: 120px; height: 32px;">
                <asp:RadioButton ID="RadioButton1" runat="server" Text="Male" GroupName="Gender" />
                <asp:RadioButton ID="RadioButton2" runat="server" Text="Female" GroupName="Gender" /></td>
            <td style="width: 205px; height: 32px;">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px">
                <asp:Label ID="Label2" runat="server" Text="Group"></asp:Label></td>
            <td style="width: 120px; height: 32px">
                &nbsp;<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px">
                <asp:Label ID="Label12" runat="server" Text="Enter Kyu"></asp:Label></td>
            <td style="width: 120px; height: 32px">
                <asp:TextBox ID="TextBox11" runat="server"></asp:TextBox></td>
            <td style="width: 205px; height: 32px">
            </td>
        </tr>
        <tr>
            <td style="width: 185px; height: 32px;">
            </td>
            <td style="width: 120px; height: 32px;">
                <asp:Button ID="Button2" runat="server" Text="Save" OnClick="Button2_Click" /></td>
            <td style="width: 205px; height: 32px;">
                <asp:Button ID="Button4" runat="server" Text="Delete" OnClick="Button4_Click" />&nbsp;&nbsp;
                &nbsp;
                <asp:Label ID ="lblDelete" runat ="server"></asp:Label></td>
        </tr>
    </table>
    <table style="width: 560px; height: 8px">
        <tr>
            <td style="width: 184px">
            </td>
            <td style="width: 158px">
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="Hall Ticket" /></td>
            <td style="width: 204px">
            </td>
        </tr>        
    </table>  
     <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:semascon %>"
             SelectCommand="select  case when len(T.hallticketno)=1 then '0000'+ convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=2 then '000'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=3  then '00'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=4  then '0'+ Convert(varchar(20),T.hallticketno)&#13;&#10; when len(T.hallticketno)=5  then  Convert(varchar(20),T.hallticketno)  end as Hallticketno &#13;&#10;,T.Studentname,(select senseiname from senseimaster where senseiid=T.senseiID) as SenseiName,(select kyuname from kyumaster where kyuid= T.kyuid) as Kyu,(select groupname from groupmaster where groupid= T.groupid) as GroupName,T.Fathername,convert(varchar(20),T.dob,103) as Dob,  case when T.sex=0 then 'Male' else 'Female' end as Gender&#13;&#10;from applicationForm T  where Franchiseid =@FRANCHISEID and Competitionid=@competitionId&#13;&#10;order by groupname ">
    </asp:SqlDataSource>
  <%--  <asp:Repeater ID ="Repeater1" runat ="server" Visible ="false"  >--%>
    <%--<HeaderTemplate>
        <table border="1" cellpadding="5" cellspacing="2">
        <tr bgcolor="gray">
        <td><b>CompanyName</b>
        </td>
        <td><b>City</b></td>
        </tr>
        </HeaderTemplate>
         <ItemTemplate>
         <tr>
         <td>
         <%#DataBinder.Eval(Container.DataItem, "CompanyName")%>
         </td>
             <td>
         <%#DataBinder.Eval(Container.DataItem, "City")%>   
             </td>
             </tr>
         </ItemTemplate> --%>       
                        
         
         
    <table id ="sample " border ="1px" visible ="false" >    
        <tr>
        <asp:Label ID="Label13" runat ="server" Font-Bold="true" Text ='<%#Bind(CompetitionName)%>' ></asp:Label><td style="width: 100px">            
            </td>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
            </td>
        </tr>     
        <tr>
            <td style="width: 100px">
                Venue</td>
            <td style="width: 106px">
            <asp:Label ID="Label14" runat ="server" Font-Bold="true" Text ='<%Bind(competitionaddress) %>'  ></asp:Label>
            </td>
            <td style="width: 127px">
                Date of Competition</td>
            <td style="width: 129px">
            <asp:Label ID ="Label15" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
                Hall Ticket No</td>
            <td style="width: 106px">
            <asp:Label Font-Bold="true" Font-Size="X-Large"  ID="Label16" runat="server"  ></asp:Label>	
            </td>
            <td style="width: 127px">
                Group</td>
            <td style="width: 129px">
            <asp:Label ID="Label17" runat="server"  Font-Bold="true"></asp:Label>
            <%--<asp:Label ID="Lable1" runat ="server" Font-Bold="true"  Text ='<%Bind("GroupName")%>'></asp:Label>--%>
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
                Student Name</td>
            <td style="width: 106px">
            <asp:Label  ID ="Lable18" runat ="server" ></asp:Label>
            </td>
            <td style="width: 127px">
                Kyu</td>
            <td style="width: 129px">
            <asp:Label ID="Lable19" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td rowspan="3" style="width: 100px">
            </td>
            <td style="width: 106px">
            <asp:Label ID ="Lable20" runat ="server" ></asp:Label>
            </td>
            <td style="width: 127px">
                Franchise Name</td>
            <td style="width: 129px">
            <asp:Label ID ="Lable21" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
                Sensei's Name</td>
            <td style="width: 129px">
            <asp:Label ID ="Lable22" runat ="server" ></asp:Label>
            </td>
        </tr>
        <tr>
            <td style="width: 106px">
            </td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
            </td>
        </tr>
        <tr>
            <td style="width: 100px">
            </td>
            <td style="width: 106px">
                Signature of HO</td>
            <td style="width: 127px">
            </td>
            <td style="width: 129px">
                Signature of Student</td>
        </tr>
    </table>
   
     
    <%--</asp:Repeater> --%>
</asp:Content>


if i click the Hall Ticket then the data sholud be bound to particular field...how to do friends plz help me...
