من با این تو 2005 کار می کنم این یه نمونه تقریبی از یه کارتابل هست
یه مدل دیگه از ریپیتر رو هم دارم اگه کافی نبود بگو بزارم واست
<script runat="server">
SqlConnection masir;
DateTime zaman;
string Color = "";
DataTable dt = new DataTable();
int bound = 0;
public void Page_Load(object sender, EventArgs e) {
string LOGINTO = Session["Login"].ToString();
if (LOGINTO == "no")
{
Response.Redirect("Login.aspx");
}
Color = Application["Color"].ToString();
masir = new SqlConnection(Application["Server"].ToString());
zaman = DateTime.Now;
if (!IsPostBack)
{
dt.Columns.Add(new DataColumn("Select"));
dt.Columns.Add(new DataColumn("Check"));
dt.Columns.Add(new DataColumn("TypeOf", typeof(String)));
dt.Columns.Add(new DataColumn("File_Name", typeof(String)));
dt.Columns.Add(new DataColumn("Upload_Date", typeof(String)));
DataRow drr;
masir.Open();
SqlDataAdapter dbas = new SqlDataAdapter("select Username_send,Subject,Zaman,read_m from cartabl where Username='"+Session["User"].ToString()+"'", masir);
DataSet dsa = new DataSet();
dbas.Fill(dsa, "cartabl");
string chk = "";
foreach (DataRow dr in dsa.Tables["cartabl"].Rows)
{
drr = dt.NewRow();
drr[3] = dr[1].ToString();
drr[4] = dr[0].ToString();
drr[2] = dr[2].ToString();
chk = dr[3].ToString();
if (chk == "False")
{
drr[1] = "<img src='img/pakatebaste.bmp' />";
}
else {
drr[1] = "<img src='img/pakatebaz.bmp' />";
}
dt.Rows.Add(drr);
}
rp.DataSource = dt;
rp.DataBind();
masir.Close();
}
}
public void rp_bound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
CheckBox ch = e.Item.FindControl("ch") as CheckBox;
DataRowView row = e.Item.DataItem as DataRowView;
ch.Attributes.Add("Iid", row["TypeOf"].ToString().Trim());
LinkButton hyper = e.Item.FindControl("hyper") as LinkButton;
hyper.Attributes.Add("hi", row["TypeOf"].ToString().Trim());
hyper.Text = row["File_Name"].ToString();
Label lbl = e.Item.FindControl("lbl") as Label;
}
}
public void check(object s, RepeaterCommandEventArgs e)
{
foreach (RepeaterItem rpi in rp.Items)
{
LinkButton hyper = rpi.FindControl("hyper") as LinkButton;
if (e.Item.ItemIndex == rpi.ItemIndex)
{
Session["Subject"] = hyper.Text.Trim();
//Response.Write(Session["Subject"].ToString());
}
}
foreach (RepeaterItem rpp in rp.Items)
{
Label lbl = rpp.FindControl("lbl") as Label;
if (e.Item.ItemIndex == rpp.ItemIndex)
{
Session["Time"] = lbl.Text;
//Response.Write(lbl.Text);
Response.Redirect("message_board.aspx");
}
}
}
public void Delete(object sender, EventArgs e)
{
string map = MapPath("");
foreach (RepeaterItem rpi in rp.Items)
{
CheckBox ch = rpi.FindControl("ch") as CheckBox;
if (ch.Checked)
{
string fi = ch.Attributes["Iid"];
//Response.Write(fi);
masir.Open();
SqlCommand taxi = new SqlCommand();
taxi.Connection = masir;
taxi.CommandText = "Delete Cartabl where Zaman='"+fi+"'";
taxi.ExecuteNonQuery();
masir.Close();
}
}
Response.Redirect("Cartabl.aspx");
}
</script>
<asp:Repeater ID="rp" runat="server" OnItemCommand="check" OnItemDataBound="rp_bound" >
<HeaderTemplate>
<table border="0" width="60%">
<tr bgcolor="#E17546">
<td width="1%"><center><font face="Arial" size="2" color="#FFFFFF"><b>Select</b></font></center></td>
<td width="1%"><center><font face="Arial" size="2" color="#FFFFFF"><b>Check</b></font></center></td>
<td width="40%"><center><font face="Arial" size="2" color="#FFFFFF"><b>Time</b></font></center></td>
<td width="50%"><center><font face="Arial" size="2" color="#FFFFFF"><b>Subject</b></font></center></td>
<td width="50%"><center><font face="Arial" size="2" color="#FFFFFF"><b>User</b></font></center></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr bgcolor="#fffff" >
<td width="1%" valign="top"><center><b><font face="Arial" size="2"><asp:CheckBox ID="ch" runat="server" /></font></b></center></td>
<td width="2%" valign="top"><b><font face="Arial" size="2"><center> <%# DataBinder.Eval (Container.DataItem, "Check") %></center></font></b></td>
<td width="2%" valign="top"><b><font face="Arial" size="2"><center><asp:Label runat="server" ID="lbl" Text='<%# DataBinder.Eval (Container.DataItem, "TypeOf") %>'></asp:Label></center></font></b></td>
<td width="20%" valign="top"><b><font face="Arial" size="2"><center><asp:LinkButton ID="hyper" runat="server"></asp:LinkButton></center></font></b></td>
<td width="20%" valign="top"><center><b><font face="Arial" size="2"><center><%# DataBinder.Eval (Container.DataItem, "Upload_Date") %></center></font></b></center></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>