Bind (Populate) Repeater with Stored Procedure using C# in ASP.Net

Hi haocaocu,

I have created sample that full fill-your requirement.

SQL

CREATE PROCEDURE Test
AS
BEGIN
	DECLARE @Test AS TABLE
	(
	idNhanViec INT,VanBanDinhKem VARCHAR(MAX),NguoiGiao VARCHAR(50),NoiDungChiDao VARCHAR(50),UserGiaoViec VARCHAR(50),
	NgayGiao DATETIME,NgayHoanThanh DATETIME,TrangThai INT,idGiaoViec INT,UserNhanviec VARCHAR(50)
	)
	INSERT INTO @Test VALUES(6,'<a href="http://localhost/iDOC/iDOiewPubli.aspx">150/QD-HDTV-TCKT</a>','Nhan Do Nhat Vy (tphhkyl)','<p> Chi ly bao cao</p>','tphndnvy','2015/11/04','2015/11/09',0,6,'tphhkly')
	INSERT INTO @Test VALUES(5,'<a href="http://localhost/iDOC/iDOiewPubli.aspx">NHoTP-DV</a>','Nhan Do Nhat Vy (tphhkyl)','<p> dfsd</p>','tphndnvy','2015/11/05','2015/11/09',0,5,'tphhkly')

	SELECT * FROM @Test
END

HTML

<asp:Repeater ID="rptDetails" runat="server">
    <HeaderTemplate>
        <table border="1">
            <tr>
                <th>
                    idNhanViec
                </th>
                <th>
                    VanBanDinhKem
                </th>
                <th>
                    NguoiGiao
                </th>
                <th>
                    NoiDungChiDao
                </th>
                <th>
                    UserGiaoViec
                </th>
                <th>
                    NgayGiao
                </th>
                <th>
                    NgayHoanThanh
                </th>
                <th>
                    TrangThai
                </th>
                <th>
                    idGiaoViec
                </th>
                <th>
                    UserNhanviec
                </th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td align="center">
                <%# Eval("idNhanViec")%>
            </td>
            <td>
                <%# Eval("VanBanDinhKem")%>
            </td>
            <td>
                <%# Eval("NguoiGiao")%>
            </td>
            <td>
                <%# Eval("NoiDungChiDao")%>
            </td>
            <td>
                <%# Eval("UserGiaoViec")%>
            </td>
            <td align="center">
                <%# Eval("NgayGiao","{0:dd/MM/yyyy}")%>
            </td>
            <td align="center">
                <%# Eval("NgayHoanThanh", "{0:dd/MM/yyyy}")%>
            </td>
            <td align="center">
                <%# Eval("TrangThai")%>
            </td>
            <td align="center">
                <%# Eval("idGiaoViec")%>
            </td>
            <td>
                <%# Eval("UserNhanviec")%>
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        string str = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string query = "Test";
        using (SqlConnection con = new SqlConnection(str))
        {
            using (SqlCommand cmd = new SqlCommand(query, con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                rptDetails.DataSource = ds;
                rptDetails.DataBind();
            }
        }
    }
}

Screenshot