protected void Ratiomgmt_grid_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete_ratio")
        {
            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 FEEDRATIO WHERE ID=@ID";
                    Comm.Parameters.Add("@ID", SqlDbType.Int);
                    Comm.Parameters["@ID"].Value = Ratiomgmt_grid.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString();

                    Comm.ExecuteNonQuery();
                    Ratiomgmt_grid.DataBind();

                    Error_lb.ForeColor = Color.Green;
                    Error_lb.Text      = "Data deleted";
                }
                catch (SqlException E)
                {
                    Error_lb.Text = E.Message;
                    return;
                }
            }
        }
    }
    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 FEEDRATIO (NAME, COPERCENT, ROPERCENT, SUPERCENT) VALUES (@NAME, @COPERCENT, @ROPERCENT, @SUPERCENT)";
                Comm.Parameters.Add("@NAME", SqlDbType.NVarChar);
                Comm.Parameters["@NAME"].Value = Name_edt.Text.Trim();
                Comm.Parameters.Add("@COPERCENT", SqlDbType.Int);
                Comm.Parameters["@COPERCENT"].Value = Copercent_edt.Text.Trim();
                Comm.Parameters.Add("@ROPERCENT", SqlDbType.Int);
                Comm.Parameters["@ROPERCENT"].Value = Ropercent_edt.Text.Trim();
                Comm.Parameters.Add("@SUPERCENT", SqlDbType.Int);
                Comm.Parameters["@SUPERCENT"].Value = Supercent_edt.Text.Trim();


                Comm.ExecuteNonQuery();
                Ratiomgmt_grid.DataBind();



                Name_edt.Text      = "";
                Copercent_edt.Text = "";
                Ropercent_edt.Text = "";
                Supercent_edt.Text = "";



                Error_lb.ForeColor = Color.Green;
                Error_lb.Text      = "Data added successfully";
            }
            catch (SqlException E)
            {
                Error_lb.Text = E.Message;
                return;
            }
        }
    }
 protected void Ratiomgmt_grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
 {
     SqlDataSource1.UpdateCommand = @"UPDATE FEEDRATIO SET NAME = @NAME, COPERCENT = @COPERCENT, ROPERCENT = @ROPERCENT, SUPERCENT = @SUPERCENT WHERE ID = @ID";
     Ratiomgmt_grid.DataBind();
 }