how to bind the data form dAtabase in c#
<p>&lt;%@ Page Language="C#" MasterPageFile="~/AdminMaster.master" AutoEventWireup="true" CodeFile="CompetitionApplication.aspx.cs" Inherits="admin_CompetitionApplication" Title="Untitled Page" %>
</p>


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

<pre><code>&lt;table style="width: 560px; height: 8px"&gt;
    &lt;tr&gt;
        &lt;td style="width: 184px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 158px"&gt;
            &lt;asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="Hall Ticket" /&gt;&lt;/td&gt;
        &lt;td style="width: 204px"&gt;
        &lt;/td&gt;
    &lt;/tr&gt;        
&lt;/table&gt;  
 &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="&lt;%$ ConnectionStrings:semascon %&gt;"
         SelectCommand="select  case when len(T.hallticketno)=1 then '0000'+ convert(varchar(20),T.hallticketno)&amp;#13;&amp;#10; when len(T.hallticketno)=2 then '000'+ Convert(varchar(20),T.hallticketno)&amp;#13;&amp;#10; when len(T.hallticketno)=3  then '00'+ Convert(varchar(20),T.hallticketno)&amp;#13;&amp;#10; when len(T.hallticketno)=4  then '0'+ Convert(varchar(20),T.hallticketno)&amp;#13;&amp;#10; when len(T.hallticketno)=5  then  Convert(varchar(20),T.hallticketno)  end as Hallticketno &amp;#13;&amp;#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&amp;#13;&amp;#10;from applicationForm T  where Franchiseid =@FRANCHISEID and Competitionid=@competitionId&amp;#13;&amp;#10;order by groupname "&gt;
&lt;/asp:SqlDataSource&gt;
</code></pre>

<p>&lt;%--  --%>
    &lt;%--
        
        
        <b>CompanyName</b>
        
        <b>City</b>
        
        
         
         
         
         &lt;%#DataBinder.Eval(Container.DataItem, "CompanyName")%>
         
             
         &lt;%#DataBinder.Eval(Container.DataItem, "City")%><br>
             
             
          --%>       </p>

<pre><code>&lt;table id ="sample " border ="1px" visible ="false" &gt;    
    &lt;tr&gt;
    &lt;asp:Label ID="Label13" runat ="server" Font-Bold="true" Text ='&lt;%#Bind(CompetitionName)%&gt;' &gt;&lt;/asp:Label&gt;&lt;td style="width: 100px"&gt;            
        &lt;/td&gt;
        &lt;td style="width: 106px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;/td&gt;
    &lt;/tr&gt;     
    &lt;tr&gt;
        &lt;td style="width: 100px"&gt;
            Venue&lt;/td&gt;
        &lt;td style="width: 106px"&gt;
        &lt;asp:Label ID="Label14" runat ="server" Font-Bold="true" Text ='&lt;%Bind(competitionaddress) %&gt;'  &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
            Date of Competition&lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;asp:Label ID ="Label15" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td style="width: 100px"&gt;
            Hall Ticket No&lt;/td&gt;
        &lt;td style="width: 106px"&gt;
        &lt;asp:Label Font-Bold="true" Font-Size="X-Large"  ID="Label16" runat="server"  &gt;&lt;/asp:Label&gt; 
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
            Group&lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;asp:Label ID="Label17" runat="server"  Font-Bold="true"&gt;&lt;/asp:Label&gt;
        &lt;%--&lt;asp:Label ID="Lable1" runat ="server" Font-Bold="true"  Text ='&lt;%Bind("GroupName")%&gt;'&gt;&lt;/asp:Label&gt;--%&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td style="width: 100px"&gt;
            Student Name&lt;/td&gt;
        &lt;td style="width: 106px"&gt;
        &lt;asp:Label  ID ="Lable18" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
            Kyu&lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;asp:Label ID="Lable19" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td rowspan="3" style="width: 100px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 106px"&gt;
        &lt;asp:Label ID ="Lable20" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
            Franchise Name&lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;asp:Label ID ="Lable21" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td style="width: 106px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
            Sensei's Name&lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;asp:Label ID ="Lable22" runat ="server" &gt;&lt;/asp:Label&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td style="width: 106px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 127px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 129px"&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td style="width: 100px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 106px"&gt;
            Signature of HO&lt;/td&gt;
        &lt;td style="width: 127px"&gt;
        &lt;/td&gt;
        &lt;td style="width: 129px"&gt;
            Signature of Student&lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;


&lt;%--&lt;/asp:Repeater&gt; --%&gt;
</code></pre>

<p></p>

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