fakhravari
دوشنبه 29 آبان 1391, 16:30 عصر
ساده ^ 10
public void ChekRateID(bool st, int PostID)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["DatabaseConnectionString1"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "UPDATE Table1 SET active =@active where id=@id";
cmd.Parameters.Add("@active", SqlDbType.Bit).Value = st;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = PostID;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ediit")
{
GridViewRow row = (GridViewRow)((Button)e.CommandSource).NamingConta iner;
CheckBox ch = (CheckBox)row.FindControl("CheckBox1");
ChekRateID(ch.Checked, int.Parse(e.CommandArgument.ToString()));
}
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display."
OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("lastnaame")%>'></asp:Label>
<br />
<asp:Label ID="Label2" runat="server" Text='<%# Eval("firstname")%>'></asp:Label>
<br />
<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("active") %>' />
<asp:Button ID="Button1" runat="server" Text="ویرایش" CommandName="ediit" CommandArgument='<%# Eval("id") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>