how to dynamically using repeater control

Hi...

i had a table

sno	title	query
1	Total Customer	select isnull(sum(cus_id),0) from customer
2	Total Products	select isnull(sum(prod_id),0) from product

what i tried

in .aspx

in aspx.cs

public void bindrepeater()
{
using (SqlConnection con = new SqlConnection(constr))
{
DataTable dt = new DataTable();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from DashBoard order by dash_order", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
dt = ds.Tables[0];
rtrDashboard.DataSource = dt;
rtrDashboard.DataBind();
}
catch (Exception ex)
{
ex.Message.ToString();
}
finally
{
con.Close();
}
}
}

i don't know how to execute 3rd column query and set the value in label

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonu Gupta7y ago
Accepted answer
Hi,

User the Repeater ItemDataBound command to perform this -

protected void OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//write the required code

}
}
+3
Sonu Gupta7y ago
Welcome @Jeenath...
0
jeenath kumar7y ago
Its Working
Thankyou @Sonu Gupta
0
Sonu Gupta7y ago
Visit to below link -
https://www.aspsnippets.com/Articles/Using-Repeater-ItemDataBound-event-in-ASPNet-example.aspx
+1
jeenath kumar7y ago
I don't know how to write. i'm new to c# how to execute that query and bind it on label or if you have better way to do this please send me
0