how to sort in gridview using template fields

Question

The sorting works fine when u fill the gridview using SQL datasource in the aspx page...

but now i am using template field and the columns are filled separately in the codebehind and the sorting is not working...

my code is

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" 
                          AutoGenerateColumns="False" 
                           ondatabound="GridView1_DataBound" 
                        onrowdatabound="GridView1_RowDataBound">


               <Columns>
               <asp:TemplateField HeaderText="File Name" ItemStyle-Width="40%"  >
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server"></asp:Label>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Failure Count" ItemStyle-Width="10%" >
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server"></asp:Label>
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle"  />
                            </asp:TemplateField>
               </Columns></GridView>

and my codebehind is:

    DataTable dt = new DataTable();
        SqlConnection connection = new SqlConnection();
        connection.ConnectionString = ConfigurationManager.ConnectionStrings["SumooHAgentDBConnectionString"].ConnectionString;
        connection.Open();
        SqlCommand sqlCmd = new SqlCommand("SELECT  FileName,FailureCount from Files where MachineID=@strID , connection);
        SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
        sqlCmd.Parameters.AddWithValue("strID", strID);

        sqlDa.Fill(dt);

        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string nameoffiles = dt.Rows[i]["FileName"].ToString();
                buFailureCode.Add(code);
                string count = dt.Rows[i]["BuFailureCount"].ToString();
                buFailureCount.Add(count);
            }

        }
        connection.Close();
    }


 protected void GridView1_DataBound(object sender, EventArgs e)
    {
        if (namesOfFiles.Count != 0)
        {
            for (int i = 0; i < namesOfFiles.Count; i++)
            {
                GridViewRow myRow = GridView1.Rows[i];
                Label Label1 = (Label)myRow.FindControl("Label1");

                Label Label3 = (Label)myRow.FindControl("Label3");
                Label1.Text = namesOfFiles[i].ToString();

                Label3.Text = buFailureCount[i].ToString();

            }}}

Answer 1

I think you'll have to handle the OnSorting event and do the actual sorting yourself in code-behind. The API documentation has an example.

Answer 2

set SortExpression