Ejemplo n.º 1
0
    protected void Herdmgmt_grid_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete_herd")
        {
            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 ANIMALS WHERE ID=@ID";
                    Comm.Parameters.Add("@ID", SqlDbType.Int);
                    Comm.Parameters["@ID"].Value = Herdmgmt_grid.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString();

                    Comm.ExecuteNonQuery();
                    Herdmgmt_grid.DataBind();

                    Error_lb.ForeColor = Color.Green;
                    Error_lb.Text      = "Data deleted";
                }
                catch (SqlException E)
                {
                    Error_lb.Text = E.Message;
                    return;
                }
            }
        }
    }
Ejemplo n.º 2
0
    protected void Herdmgmt_grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        DropDownList DDL = (DropDownList)Herdmgmt_grid.Rows[e.RowIndex].FindControl("Animalcat_grid_ddl");

        if (DDL != null)
        {
            e.NewValues["ANIMALGROUPID"] = DDL.SelectedItem.Value;
            SqlDataSource1.UpdateCommand = @"UPDATE ANIMALS SET NAME = @NAME, ANIMALGROUPID = @ANIMALGROUPID, ANIMALWEIGHTID = @ANIMALWEIGHTID, ANIMALAGEID = @ANIMALAGEID WHERE ANIMALS.ID = @ID";
        }


        DropDownList DDL1 = (DropDownList)Herdmgmt_grid.Rows[e.RowIndex].FindControl("Animalage_grid_ddl");

        if (DDL1 != null)
        {
            e.NewValues["ANIMALAGEID"]   = DDL1.SelectedItem.Value;
            SqlDataSource1.UpdateCommand = @"UPDATE ANIMALS SET NAME = @NAME, ANIMALGROUPID = @ANIMALGROUPID, ANIMALWEIGHTID = @ANIMALWEIGHTID, ANIMALAGEID = @ANIMALAGEID WHERE ANIMALS.ID = @ID";
        }

        DropDownList DDL2 = (DropDownList)Herdmgmt_grid.Rows[e.RowIndex].FindControl("Animalweight_grid_ddl");

        if (DDL2 != null)
        {
            e.NewValues["ANIMALWEIGHTID"] = DDL2.SelectedItem.Value;
            SqlDataSource1.UpdateCommand  = @"UPDATE ANIMALS SET NAME = @NAME, ANIMALGROUPID = @ANIMALGROUPID, ANIMALWEIGHTID = @ANIMALWEIGHTID, ANIMALAGEID = @ANIMALAGEID WHERE ANIMALS.ID = @ID";
        }


        Herdmgmt_grid.DataBind();
    }
Ejemplo n.º 3
0
    protected void add_btn_Click(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 ANIMALS (NAME, ANIMALGROUPID, ANIMALWEIGHTID, ANIMALAGEID) VALUES (@NAME, @ANIMALGROUPID, @ANIMALWEIGHTID, @ANIMALAGEID)";
                Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
                Comm.Parameters["@NAME"].Value = Herdname_edt2.Text.Trim();
                Comm.Parameters.Add("@ANIMALGROUPID", SqlDbType.Int);
                Comm.Parameters["@ANIMALGROUPID"].Value = Animalcat_ddl.SelectedValue;
                Comm.Parameters.Add("@ANIMALAGEID", SqlDbType.Int);
                Comm.Parameters["@ANIMALAGEID"].Value = Animalage_ddl0.SelectedValue;
                Comm.Parameters.Add("@ANIMALWEIGHTID", SqlDbType.Int);
                Comm.Parameters["@ANIMALWEIGHTID"].Value = Weight_ddl1.SelectedValue;

                Comm.ExecuteNonQuery();
                Herdmgmt_grid.DataBind();

                Herdname_edt2.Text           = "";
                Animalcat_ddl.SelectedIndex  = 0;
                Animalage_ddl0.SelectedIndex = 0;
                Weight_ddl1.SelectedIndex    = 0;


                Error_lb.ForeColor = Color.Green;
                Error_lb.Text      = "Data added successfully";
            }
            catch (SqlException E)
            {
                Error_lb.Text = E.Message;
                return;
            }
        }
    }