how to change the values of label in listview from codebehind?

Question

0.00/5 (No votes)

See more:

Actually i'm developing template using asp.net and c#.
i'm using listview at my ascx page and my ItemTemplate is as below:

<ItemTemplate>
<tr style="background-color:#FFF8DC;color: #000000;">
    <td>
        <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" CausesValidation="false" OnClientClick="return confirm('Are you sure you want to delete this Product Details?');" />
        <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" CausesValidation="True" />
    </td>
    <td>
        <asp:Label ID="EmpIDLabel" runat="server" Text='<%# Eval("EmpID") %>' />
    </td>
    <td>
        <asp:Label ID="EmpNameLabel" runat="server" Text='<%# Eval("EmpName") %>' />
    </td>
    <td>
        <asp:Label ID="DepartmentLabel" runat="server" Text='<%# Eval("Department") %>' />
    </td>
    <td>
        <asp:Label ID="AgeLabel" runat="server" Text='<%# Eval("Age") %>' />
    </td>
    <td>
        <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
    </td>
</tr>
</ItemTemplate>

and i retrieve the data from the database in ascx code behind as bellow:

public DataTable GetEmployee(string query)
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
    SqlDataAdapter ada = new SqlDataAdapter(query, con);
    DataTable dtEmp = new DataTable();
    ada.Fill(dtEmp);
    return dtEmp;
}

and also i bind the data in ascx code behind as follow:

private void BindLVP(string SortExpression)
{
    string UpdateQuery = "Select * from Employee" + SortExpression;
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
    hid_UpdateQTP.Value = UpdateQuery;

    lvProduct.Items.Clear();
    lvProduct.DataSource = GetEmployee(UpdateQuery);
    lvProduct.DataBind();
}

my question is how i can delete the <%# Eval("EmpID") %> and all the other label text like this in ItemTemplate and change the label.text in ItemTemplate from the code behind, i mean pass the data of the database to these label from code behind.
appreciate your consideration.

Posted 13-Dec-11 22:51pm

Far sh

Add a Solution

3 solutions

Solution 1

ON ItemDataBound this event will run for each row of the listview.

And you can modify the data for each row and can access controls of each row.

check this exapmle:

VB

If (e.Item.ItemType = ListViewItemType.DataItem) Then
               Dim divCatHeader = e.Item.FindControl("divCatHeader")

               Dim lblWeekNbrWeekYr As Label = CType(e.Item.FindControl("lblWeekNbrWeekYr"), Label)
               If catg_cnt = 3 Then
                   divCatHeader.Visible = True
                   catg_cnt = 1
               Else
                   catg_cnt = catg_cnt + 1
               End If

               If (sales_unit = "sales") Then
                   lblWeekNbrWeekYr.text = "Week " & week_nbr & " FYE " & week_yr & " Sales"
               Else
                   lblWeekNbrWeekYr.Text = "Week " & week_nbr & " FYE " & week_yr & " Units"
               End If
           End If

Posted 13-Dec-11 23:46pm

Anuj Banka

Solution 2

try this blog
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowdatabound.aspx[^]
--NDK

Posted 14-Dec-11 9:59am

NandaKumer

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Far sh · Accepted Answer · 2011-12-15T15:26:00

thanks all for the reply, i have used the itemDataBound event of the listview as bellow:

<asp:listview id="lvProduct" runat="server" onitemdatabound="lvProduct_ItemDataBound" >
</asp:listview>

then at the code behind i have get the data from database and pass it to the label in listview.

protected void lvProduct_ItemDataBound(object sender, ListViewItemEventArgs e)
   {
       if (e.Item.ItemType == ListViewItemType.DataItem)
       {
           Label EmpIDLabel = (Label)e.Item.FindControl("EmpIDLabel");
           System.Data.DataRowView rowView = e.Item.DataItem as System.Data.DataRowView;
           EmpIDLabel.Text = rowView["EmpID"].ToString();
       }
   }