MOJTABAATEFEH
سه شنبه 25 شهریور 1393, 10:02 صبح
<asp:GridView ID="GridView1" Width="600" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="id" DataSourceID="LinqDataSource1" OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="id" HeaderText="شماره" InsertVisible="False" ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="Title" HeaderText="عنوان" SortExpression="Title" />
<asp:BoundField DataField="Date" HeaderText="تاریخ انتشار" SortExpression="Date" />
<asp:BoundField DataField="Price" HeaderText="قیمت" SortExpression="Price" />
<asp:buttonfield commandName="cmd_del" HeaderText="حذف" Text="حذف" />
<asp:ButtonField CommandName="cmd_edit" HeaderText="ویرایش" Text="ویرایش" />
</Columns>
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<SortedAscendingCellStyle BackColor="#FEFCEB" />
<SortedAscendingHeaderStyle BackColor="#AF0101" />
<SortedDescendingCellStyle BackColor="#F6F0C0" />
<SortedDescendingHeaderStyle BackColor="#7E0000" />
</asp:GridView>
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmd_edit")
{
int rowid = int.Parse(e.CommandArgument.ToString());
int del = int.Parse(e.CommandArgument.ToString());
int del1 = int.Parse(GridView1.Rows[del].Cells[0].Text);
DataClasses1DataContext db = new DataClasses1DataContext();
var Qdel = db.tbl_Posts.Where(c => c.id == del1).Single();
}
else if (e.CommandName == "cmd_del")
{
int del = int.Parse(e.CommandArgument.ToString());
int del1 = int.Parse(GridView1.Rows[del].Cells[0].Text);
DataClasses1DataContext db = new DataClasses1DataContext();
var Qdel = db.tbl_Posts.Where(c => c.id == del1).Single();
db.tbl_Posts.DeleteOnSubmit(Qdel);
db.SubmitChanges();
GridView1.DataBind();
}
}