how to show monthly attendance of an employee in a reapter

Hi,

add Repeater control in your design page ....

empId	empName	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
Text='<%# Eval("empId") %>' />	Text='<%# Eval("empName") %>' />	Text='<%# Eval("1") %>' />	Text='<%# Eval("2") %>' />	Text='<%# Eval("3") %>' />	Text='<%# Eval("4") %>' />	Text='<%# Eval("5") %>' />	Text='<%# Eval("6") %>' />	Text='<%# Eval("7") %>' />	Text='<%# Eval("8") %>' />	Text='<%# Eval("9") %>' />	Text='<%# Eval("10") %>' />	Text='<%# Eval("11") %>' />	Text='<%# Eval("12") %>' />	Text='<%# Eval("13") %>' />	Text='<%# Eval("14") %>' />	Text='<%# Eval("15") %>' />	Text='<%# Eval("16") %>' />	Text='<%# Eval("17") %>' />	Text='<%# Eval("18") %>' />	Text='<%# Eval("19") %>' />	Text='<%# Eval("20") %>' />	Text='<%# Eval("21") %>' />	Text='<%# Eval("22") %>' />	Text='<%# Eval("23") %>' />	Text='<%# Eval("24") %>' />	Text='<%# Eval("25") %>' />	Text='<%# Eval("26") %>' />	Text='<%# Eval("27") %>' />	Text='<%# Eval("28") %>' />	Text='<%# Eval("29") %>' />	Text='<%# Eval("30") %>' />
Text='<%# Eval("empId") %>' />	Text='<%# Eval("empName") %>' />	Text='<%# Eval("1") %>' />	Text='<%# Eval("2") %>' />	Text='<%# Eval("3") %>' />	Text='<%# Eval("4") %>' />	Text='<%# Eval("5") %>' />	Text='<%# Eval("6") %>' />	Text='<%# Eval("7") %>' />	Text='<%# Eval("8") %>' />	Text='<%# Eval("9") %>' />	Text='<%# Eval("10") %>' />	Text='<%# Eval("11") %>' />	Text='<%# Eval("12") %>' />	Text='<%# Eval("13") %>' />	Text='<%# Eval("14") %>' />	Text='<%# Eval("15") %>' />	Text='<%# Eval("16") %>' />	Text='<%# Eval("17") %>' />	Text='<%# Eval("18") %>' />	Text='<%# Eval("19") %>' />	Text='<%# Eval("20") %>' />	Text='<%# Eval("21") %>' />	Text='<%# Eval("22") %>' />	Text='<%# Eval("23") %>' />	Text='<%# Eval("24") %>' />	Text='<%# Eval("25") %>' />	Text='<%# Eval("26") %>' />	Text='<%# Eval("27") %>' />	Text='<%# Eval("28") %>' />	Text='<%# Eval("29") %>' />	Text='<%# Eval("30") %>' />

i hope u know how to get data from data base.. so add below code in code behind .

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindRepeater();
}
}

public void bindRepeater()
{
using (SqlConnection con = new SqlConnection("Data Source=RapidProgramming;Integrated Security=true;Initial Catalog=RPDB"))//connection string of your data base
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * FROM [YOUR TABLE]", con);
SqlDataReader dr = cmd.ExecuteReader();
Repeater1.DataSource = dr;
Repeater1.DataBind();
con.Close();
}
}

7 Replies

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

Susanta Rout11y ago
sir i a fresher if you help me here then i always will grtfull to you
0
Pradeep11y ago
u can put condition in select Query know..?
If there is no date in database u can use Repeater class in code behind , set properties for that and bind it based on your condition. thats it..
0
Susanta Rout11y ago
sir i want dynamically if the i want show the month of February then
0

Pradeep11y ago

empId	empName	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
Text='<%# Eval("empId") %>' />	Text='<%# Eval("empName") %>' />	Text='<%# Eval("1") %>' />	Text='<%# Eval("2") %>' />	Text='<%# Eval("3") %>' />	Text='<%# Eval("4") %>' />	Text='<%# Eval("5") %>' />	Text='<%# Eval("6") %>' />	Text='<%# Eval("7") %>' />	Text='<%# Eval("8") %>' />	Text='<%# Eval("9") %>' />	Text='<%# Eval("10") %>' />	Text='<%# Eval("11") %>' />	Text='<%# Eval("12") %>' />	Text='<%# Eval("13") %>' />	Text='<%# Eval("14") %>' />	Text='<%# Eval("15") %>' />	Text='<%# Eval("16") %>' />	Text='<%# Eval("17") %>' />	Text='<%# Eval("18") %>' />	Text='<%# Eval("19") %>' />	Text='<%# Eval("20") %>' />	Text='<%# Eval("21") %>' />	Text='<%# Eval("22") %>' />	Text='<%# Eval("23") %>' />	Text='<%# Eval("24") %>' />	Text='<%# Eval("25") %>' />	Text='<%# Eval("26") %>' />	Text='<%# Eval("27") %>' />	Text='<%# Eval("28") %>' />	Text='<%# Eval("29") %>' />	Text='<%# Eval("30") %>' />
Text='<%# Eval("empId") %>' />	Text='<%# Eval("empName") %>' />	Text='<%# Eval("1") %>' />	Text='<%# Eval("2") %>' />	Text='<%# Eval("3") %>' />	Text='<%# Eval("4") %>' />	Text='<%# Eval("5") %>' />	Text='<%# Eval("6") %>' />	Text='<%# Eval("7") %>' />	Text='<%# Eval("8") %>' />	Text='<%# Eval("9") %>' />	Text='<%# Eval("10") %>' />	Text='<%# Eval("11") %>' />	Text='<%# Eval("12") %>' />	Text='<%# Eval("13") %>' />	Text='<%# Eval("14") %>' />	Text='<%# Eval("15") %>' />	Text='<%# Eval("16") %>' />	Text='<%# Eval("17") %>' />	Text='<%# Eval("18") %>' />	Text='<%# Eval("19") %>' />	Text='<%# Eval("20") %>' />	Text='<%# Eval("21") %>' />	Text='<%# Eval("22") %>' />	Text='<%# Eval("23") %>' />	Text='<%# Eval("24") %>' />	Text='<%# Eval("25") %>' />	Text='<%# Eval("26") %>' />	Text='<%# Eval("27") %>' />	Text='<%# Eval("28") %>' />	Text='<%# Eval("29") %>' />	Text='<%# Eval("30") %>' />

Susanta Rout11y ago
i want to show like this pardeep sir.i dont know how to show in it.my data in database is aleary there
0
Pradeep11y ago

You can just set the data source and bind it,
0
Shakti Saxena11y ago
what's your question?

are you storing data in database? or?
0