protected void add_btn_Click1(object sender, EventArgs e) { using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBpath"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Conn.Open(); try { Comm.CommandText = "INSERT INTO TARGETNAME(NAME) VALUES (@NAME)"; Comm.Parameters.Add("@NAME", SqlDbType.NVarChar); Comm.Parameters["@NAME"].Value = Targetmgmt_edt.Text.Trim(); Comm.ExecuteNonQuery(); Targetnamemgmt_grid.DataBind(); Targetmgmt_edt.Text = ""; Error_lb.ForeColor = Color.Green; Error_lb.Text = "Data added successfully"; } catch (SqlException E) { Error_lb.Text = E.Message; return; } } }
protected void Targetcatmgmt_grid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete_target") { using (SqlConnection Conn = new SqlConnection()) { Conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBpath"].ConnectionString; SqlCommand Comm = new SqlCommand(); Comm.Connection = Conn; Conn.Open(); try { Comm.CommandText = "DELETE FROM TARGETNAME WHERE ID=@ID"; Comm.Parameters.Add("@ID", SqlDbType.Int); Comm.Parameters["@ID"].Value = Targetnamemgmt_grid.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString(); Comm.ExecuteNonQuery(); Targetnamemgmt_grid.DataBind(); Error_lb.ForeColor = Color.Green; Error_lb.Text = "Data deleted"; } catch (SqlException E) { Error_lb.Text = E.Message; return; } } } }
protected void Targetcatmgmt_grid_RowUpdating(object sender, GridViewUpdateEventArgs e) { SqlDataSource1.UpdateCommand = @"UPDATE TARGETNAME SET NAME = @NAME WHERE ID = @ID"; Targetnamemgmt_grid.DataBind(); }