how to get grid view check box checked rows data into database

CREATE PROCEDURE [ProcedureName] 
	-- Add the parameters for the stored procedure here
	@Parameter1 INT
AS
BEGIN
    SET NOCOUNT ON;
	
    BEGIN TRANSACTION
    	
	-- if row alredy exists in a table update it else insert new row
    IF EXISTS ( SELECT  *
                FROM    [TableName]
                WHERE   <conditions> )
        BEGIN
            UPDATE  [TableName]
            SET     [FieldName] = [Value]
            WHERE   <conditions>
        END
    ELSE 
        BEGIN
	    INSERT INTO <tablename> VALUES <............>
        END
        
        
	 IF @@ROWCOUNT = 0 
        BEGIN
            ROLLBACK TRANSACTION
        END
    ELSE 
        BEGIN
            COMMIT TRANSACTION
        END
END

protected void btnSave_Click(object sender, EventArgs e)
        {
            SqlConnection conn = <your connectionstring="">;
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.Connection = conn;

            String sqlQuery = "";

            try
            {
               conn.Open();

               for (int i = 0; i < yourdgv.RowCount - 1; i++)
               {
                 sqlCommand.CommandText = "<yourprocedurename>";
                 sqlCommand.CommandType = CommandType.StoredProcedure;
                 sqlCommand .Parameters.AddWithValue("@parameter1", <value>);

                 sqlCommand.ExecuteNonQuery();

                 //Data insertion completed.
               }
            }
            catch (Exception)
            {
                // your exception..
            }
            finally
            {
                conn.Close();
            }
        }

protected void btnSaveData_Click(object sender, EventArgs e)
{
    foreach (GridViewRow row in grvYourGrid.Rows)
    {
        CheckBox chk = (CheckBox)row.FindControl("YourCheckBoxID");
        if (chk.Checked)
        {
            string textInTextBox =((TextBox)row.FindControl("YourTextBoxID")).Text;
            //same like for other controls
            //perform your database operation here
        }
    }
}