how to use repeater control for getting a data from a database in C#

Question

<%@ 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>   




 <table border ="1px">//In these table the Value should be inserted 
            <tr>
                <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">
                </td>
                <td style="width: 127px">
                    Date of Competition</td>
                <td style="width: 129px">
                </td>
            </tr>
            <tr>
                <td style="width: 100px">
                    Hall Ticket No</td>
                <td style="width: 106px">
                </td>
                <td style="width: 127px">
                    Group</td>
                <td style="width: 129px">
                </td>
            </tr>
            <tr>
                <td style="width: 100px">
                    Student Name</td>
                <td style="width: 106px">
                </td>
                <td style="width: 127px">
                    Kyu</td>
                <td style="width: 129px">
                </td>
            </tr>
            <tr>
                <td rowspan="3" style="width: 100px">
                </td>
                <td style="width: 106px">
                </td>
                <td style="width: 127px">
                    Franchise Name</td>
                <td style="width: 129px">
                </td>
            </tr>
            <tr>
                <td style="width: 106px">
                </td>
                <td style="width: 127px">
                    Sensei's Name</td>
                <td style="width: 129px">
                </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:Content>

hi friends the above code is Aspx page. if i click the [Hall Ticket] (Button) then the value from the Database sould be inserted in a particular field that is indicated in the above code plz help me friens....