62,244
社区成员




<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onrowdatabound="GridView1_RowDataBound">
<Columns>
<asp:TemplateField ItemStyle-Width="20">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server"
oncheckedchanged="CheckBox1_CheckedChanged" />
</ItemTemplate>
<ItemStyle Width="20px"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText="pID" SortExpression="pID" ItemStyle-Width="200" HeaderStyle-CssClass="e_hidden"
FooterStyle-CssClass="e_hidden" ItemStyle-CssClass="e_hidden">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"pID").ToString() %>'></asp:Label>
</ItemTemplate>
<FooterStyle CssClass="e_hidden"></FooterStyle>
<HeaderStyle CssClass="e_hidden"></HeaderStyle>
<ItemStyle CssClass="e_hidden" Width="200px"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText="标题" SortExpression="标题" ItemStyle-Width="150">
<ItemTemplate>
<a href='<%# "display.aspx?ID=" + DataBinder.Eval(Container.DataItem,"ID") %>'>
<asp:Label ID="Label7" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"标题").ToString() %>'></asp:Label></a>
</ItemTemplate>
<ItemStyle Width="150px"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText="分类" SortExpression="分类" ItemStyle-Width="60">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"分类").ToString() %>'></asp:Label>
</ItemTemplate>
public void GridBind()
{
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
dt2.Columns.Add("pID");
dt2.Columns.Add("标题");
foreach (DataRow dr in dt.Rows)
{
dt2.Rows.Add(
dr["pID"].ToString(),
dr["title"].ToString(),
);
}
GridView1.DataSource = dt2;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox ck = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");
if (ck.Checked)
{
string pid = GridView1.Rows[i].Cells[1].Text.Trim();
string description = GridView1.Rows[i].Cells[2].Text.Trim();
protected void Button1_Click(object sender, EventArgs e)
{
string delstrId = string.Empty;
for (int j = 0; j < GridView1.Rows.Count ; j++)
{
CheckBox chose = (CheckBox)GridView1.Rows[j].FindControl("chk");
if (chose.Checked == true)
{
delstrId += GridView1.DataKeys[j].Value;
delstrId += ",";
}
}
string _allDel = delstrId.Substring(0, delstrId.Length - 1);
string delSql = "delete from smallclass where smallclassId in ("+_allDel+")";
new OledbDataBase().ExecuteSql(delSql);
bindSmall();
}
//删除选中的数据。可全删除。全选根据ID删除
protected void delWriteLog_Click(object sender, ImageClickEventArgs e)
{
sqlt.SetSQLBeginTrans();
try
{
for (int i = 0; i < rpMyReceiveLeaveWord.Items.Count; i++)
{
CheckBox CB = (CheckBox)rpMyReceiveLeaveWord.Items[i].FindControl("single_Chk");
if (CB.Checked == true)
{
string delID = ((HiddenField)rpMyReceiveLeaveWord.Items[i].FindControl("lwid")).Value;
cookies = Request.Cookies["UserCookies"];
if (cookies != null)
{
int uid = int.Parse(cookies["User_Uid"].ToString());//
sqlt.Operate("update a set a.delstate=1 from dbo.space_MyLeaveord a inner join dbo.bbs_users b on a.spaceno=b.itemno where b.uid=" + uid + " and a.leavewordid=" + delID);
}
}
} sqlt.SetSQLCommitTrans(); sqlt.ConClose();
}
catch
{
sqlt.SetSQLRollBack(); sqlt.ConClose(); base.MessageBox("00006", null);
}
this.PageFen();
}