Пример #1
0
        protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int    ResourcesId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
            string constr      = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

            //using (SqlConnection con = new SqlConnection(constr))
            //{
            //    using (SqlCommand cmd = new SqlCommand("Resources_CRUD"))
            //    {
            //        cmd.CommandType = CommandType.StoredProcedure;
            //        cmd.Parameters.AddWithValue("@Action", "DELETE");
            //        cmd.Parameters.AddWithValue("@ResourcesId", ResourcesId);
            //        cmd.Connection = con;
            //        con.Open();
            //        cmd.ExecuteNonQuery();
            //        con.Close();
            //    }
            //}


            client = new CRUD_SPClient();

            if (client.Delete(ResourcesId))
            {
                this.BindGrid(client.DoWork().ToList());
            }

            client.Close();
            //  this.BindGrid();
        }